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 “chevrons” 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.

74 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
chevrons166546(None) 
cheverons1745201cheverons
chevron1575781chevron_
cheeros123711642cheero_s
cheveron1645262cheveron_
cheviots1643792cheviots
chevres15379792chevr_es
chevrets16255322chevrets
herons94820542_he_rons
aleurons867013aleurons
caldrons1138063caldrons
caverns124510253caver_ns
ceros74726073c_e_ro_s
cerous85821203c_e_rous
chagrins1437073chagrins
chaldrons1545493chaldrons
chamfrons1944383chamfrons
chanfrons1744623chanfrons
chansons1337473chansons
chaperons1646893chaperons
charros124312153charro_s
cheapens15305943cheapens
cheapos14418513cheapo_s
checkrows2342773checkrows
cheerers13319543cheerers
cheering143612703cheering
cheerios13317593cheerios
cheero114712943cheero__
cheers114518913cheer__s
chefdoms19123493chefdoms
chegoes1337333che_goes
chemos13311723che_mo_s
cheroot12413693che_root
cheroots1348193cheroots
cherries131812993cherries
cherts115617233che_r_ts
cherubs1434553che_rubs
chervils1644553chervils
chetrums1543913chetrums
chevies153511443chev_ies
cheviot1546933chevio_t
chevre14318313chevr__e
chevret153310633chevr_et
chevying2034053chevying
chiffons1943693chiffons
chignons1444713chignons
chiros114617773ch_iro_s
chitons122611913ch_itons
chlorins132612883chlorins
chlorous1339223chlorous
chorions13310663chorions
chronons1347353chronons
churns114910233ch_ur_ns
churros12427583churro_s
cistrons102710643cistrons
citrons92913223c_itrons
cohesions1447093cohesions
crepons1139323cre_pons
devons104512253_dev_ons
dihedrons14113873dihedrons
echelons1385543eche_lons
elevons1067573elev_ons
fleurons1155343fleurons
hadrons113314303_hadrons
herns84825583_he_r_ns
heroes94923833_he_roes
heroins103518013_he_roins
heron85025503_he_ron_
heros84930863_he_ro_s
neurons7410453_neurons
ocherous1347013oche_rous
operons91411743ope_rons
perrons93115483_perrons
thorons104511913th_orons

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.406440125.6
2DLD Change Limit146162747.32619951.1
3Display Results74740.0332242.4
 (SQL Overall)178691747.76523012.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.