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 “chevrets” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
chevrets1625532(None) 
chevres15379791chevre_s
chevret153310631chevret_
cheerers13319542cheerers
cherts115617232che_r_ts
chevalets1743382chevalets
chevies153511442chevie_s
cheviots1643782cheviots
chevre14318312chevre__
chevrons1665462chevrons
befrets1237613_befrets
berets85822523_be_rets
brevets12519393brev_ets
cabarets12268463cabarets
carets85330773c__arets
ceres75540013c_e_re_s
cereus85215523c_e_reus
cermets1139713c_ermets
certes84623083c_e_rtes
chalets122813473ch_alets
chaplets1556883chaplets
chares115631803ch_are_s
charts115823093ch_ar_ts
cheapens15305943cheapens
cheapest1536073cheapest
cheaters133613513cheaters
cheats114519543che__ats
chebecs1635013che_becs
checkers19317843checkers
cheders134512393che_ders
chedites1438263chedites
cheeks154712783che__eks
cheepers15329013cheepers
cheeps135312913che__eps
cheered133713293cheere_d
cheerer123511753cheere_r
cheeriest1438213cheeriest
cheerios13317583cheerios
cheerless1495293cheerless
cheeros123711633cheer_os
cheers114518913che__ers
cheeses123613103cheese_s
chegoes1337333chegoe_s
chelates132713843chelates
chemists152710323chemists
chequers2234103chequers
cheques2136863cheque_s
cheroots1348193cheroots
cherries131812983cherries
chert105232103che_r_t_
cherty144612473che_r_ty
cherubs1434553che_rubs
chervils1644553chervils
chesses124112633chesse_s
chests114916263che__sts
chetrums1543913chetrums
chevalet1658123chevalet_
cheveron1645263cheveron
cheverons1745203cheverons
chevied16357483chevie_d
cheviot1546933cheviot_
chevron1575783chevr_on
chewers154111143che_wers
chewiest16177293chewiest
chirres123812253chirre_s
chivarees1744383chivarees
chives144317593chiv_e_s
chivies153412853chivie_s
choreas124414203ch_oreas
chores114828023ch_ore_s
cigarets1145473cigarets
civets115212543c_iv_ets
clarets94111103c_larets
clearers10349303clearers
clearest1038653clearest
cleverest1444503cleverest
coerects1258543coe_rects
coexerts1734883coexerts
coffrets1645363coffrets
coheiress1443353coheiress
coherers132310733cohe_rers
coheres122917693cohe_re_s
converts133213553converts
corvets124715023corv_ets
coverers132712123coverers
coverlets1437053coverlets
coverts124813813cover_ts
covets114819643c_ov_ets
cressets10309103cressets
culverts13295323culverts
curets84922343c__urets
curvets12399913curv_ets
egrets72712243__egrets
everts94514893__everts
ferrets103111393_ferrets
hearers104319783_hearers
hearts96218943_hear_ts
heiress1036813_heiress
helmets12309073_helmets
heres86245903_he_re_s
hereto9313693_he_reto
leverets11297603_leverets
regrets83212923_regrets
reverts104715043_reverts
revets94022173_rev_ets
secrets9311773_secrets
shearers113911323shearers
sheerest11310083sheerest
sheets93918503she__ets
sherbets1335213sherbets
sieverts1145713sieverts
terrets72913583_terrets
theorems1344693theorems
theres96525473the_re_s
thereto1038993the_reto
trevets10499973trev_ets
vervets13419753_vervets
whereas13448903whe_reas
wheres125917433whe_re_s
whereto1346063whe_reto
wherves16548053wherve_s

Search took 7 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.423422437.4
2DLD Change Limit1461621216.25023385.9
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.71926594.9
 
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.