Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “chignons” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

75 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
chignons144471(None) 
chignon1344621chignon_
chiffons1943692chiffons
chignoned1643002chignoned
chigoes1338352chig_oes
chinone12510162chi_none
chinones13510482chi_nones
chinos115018692chi_no_s
chitons122611912chi_tons
chronons1347352chronons
mignons1037862_mignons
actinons10389453acti_nons
caissons1036283caissons
cannons94412883c_annons
canons85522063c__anons
chagrins1437073chagrins
champignons21131323champignons
chansons1337473chansons
chegoes1337333cheg_oes
chevrons1665463chevrons
chiantis1346593chiantis
chicanos1595993chicano_s
chickens19267433chickens
chicness1535593chicness
chicos134614833chi_co_s
chiffon1844053chiffon_
chiggers1535563chiggers
chigoe1237533chig_o_e
chimneys1883643chimneys
chinas115119403chi_n_as
chinbone1555163chinbone
chinbones1655033chinbones
chines115029173chi_n_es
chining133316853chi_ning
chinks155817573chi_n_ks
chinning14329663chinning
chino105823313chi_no__
chinook1675103chi_nook
chinooks1774783chinooks
chins105631463chi___ns
chints115117833chi_n_ts
chiros114617773chi_ro_s
chitinous1474993chitinous
chitins122713793chi_tins
chitlins13289393chitlins
chiton112612393chi_ton_
chorions13310663chorions
chrismons1644003chrismons
chronon1237353chronon_
cions75222853c_i__ons
citrons92913223c_itrons
cogons96818113c_og_ons
coignes103912153coign_es
coigning1237193coigning
coigns94410063coig__ns
coitions10312853coitions
crimsons1245633crimsons
epigons1048183epig_ons
hagdons1258523_hagdons
lignans8398853_lignans
lignins84010493_lignins
lorgnons943993lorgnons
mignon937953_mignon_
ninons64913773_ni_nons
phonons123310253ph_onons
pigeons1039183_pigeons
pinons86019943_pi_nons
rhinos94411123rhi_no_s
shippons15255663shippons
signors83410913_signors
thionins1177923thionins
tiglons837343_tiglons
tigons74112263_tig_ons
trigons84312093trig_ons
wigeons1136983_wigeons

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.546327272.9
2DLD Change Limit146162757.26620115.9
3Display Results75750.0302500.0
 (SQL Overall)178691757.84222786.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.