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

91 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
chevron157578(None) 
cheveron1645261cheveron
chevrons1665461chevrons
cheero114712932cheero_
cheeros123711632cheeros
cheverons1745202cheverons
cheviot1546932cheviot
chevre14318312chevr_e
chevres15379792chevres
chevret153310632chevret
heron85025502_he_ron
aleuron757383aleuron
caldron1038153caldron
cavern115312453caver_n
cero66329453c_e_ro_
ceros74726073c_e_ros
chagrin1337893chagrin
chaldron1445773chaldron
chamfron1844493chamfron
chanfron1644803chanfron
chanson1238043chanson
chaperon1547353chaperon
charro114212953charro_
charros124312143charros
cheapen14407623cheapen
cheapo134810083cheapo_
cheapos14418513cheapos
checkrow2242743checkrow
cheer105420383cheer__
cheered133713293cheered
cheerer123511753cheerer
cheering143612703cheering
cheerio12379313cheerio
cheerios13317583cheerios
cheerly15417603cheerly
cheers114518913cheer_s
cheery144913153cheer_y
chefdom18134073chefdom
chegoe1237273che_goe
chemo12313633che_mo_
chemos13311723che_mos
cheroot12413693cheroot
cherry144810763che_rry
chert105232103che_r_t
cherts115617233che_rts
cherty144612473che_rty
cherub1337263che_rub
chervil1534953chervil
chetrum1445343chetrum
chevied16357483chevied
chevies153511443chevies
cheviots1643783cheviots
chevrets16255323chevrets
chevy16479993chev__y
chevying2034053chevying
chiffon1844053chiffon
chignon1344623chignon
chiro105320343ch_iro_
chiros114617773ch_iros
chirren12388743chirren
chiton112612393ch_iton
chlorin123113003chlorin
chon96627793ch___on
chorion12311773chorion
chronon1237353chronon
churn105113103ch_ur_n
churro11448353churro_
churros12427583churros
cistron9299883cistron
citron83112983c_itron
cohesion1347283cohesion
crepon1039943cre_pon
devon95113683_dev_on
dihedron13104113dihedron
echelon1276163eche_lon
elevon977953elev_on
fleuron1055573fleuron
hadron102913753_hadron
hereon93914363_hereon
hern76134893_he_r_n
hero74635783_he_ro_
heroin94420593_he_roin
herons94820543_he_rons
heros84930863_he_ros
neuron6310373_neuron
operon8811773ope_ron
perron83216623_perron
pleuron976343pleuron
thereon10199263thereon
thoron94713903th_oron
whereon13196503whereon

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 Filter1786911340270.420425454.8
2DLD Change Limit134027916.69020033.9
3Display Results91910.0303033.3
 (SQL Overall)178691917.14025026.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.