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

147 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
crouton94713(None) 
croton84415451cro_ton
croutons1036751croutons
bouton8311532_bouton
cotton8312992c_otton
coupon102810992c_oupon
craton84517192cr_aton
croon75522782cro__on
crotons93714372cro_tons
croute84617272crout_e
croutes94815652croutes
fronton1037202fronton
mouton8410852_mouton
proton84318892pro_ton
acromion1246063acromion
blouson974893blouson
boston8513043_boston
boutons9310783_boutons
calutron1045553calutron
canton85722993c_anton
carotin92216733caro_tin
carton84522663c_arton
caution93013523c_aution
chiton112612393c_hiton
chorion12311773chorion
chorten122811303chorten
chronon1237353chro_non
clout75330463clout__
clouted104212163clouted
clouter93511693clouter
clouting113011683clouting
clouts87017203clout_s
cocoon10312263c_ocoon
codon86522853c_o_don
cogon89120903c_o_gon
coition9314313c_oition
colon78630193c_o_lon
common12310803c_ommon
conto76027173c_onto_
contos84923233c_ontos
cooktop1544043cooktop
coon67248943c_o__on
cooption1288343cooption
cordon95017293c_ordon
cornuto937033cornuto_
cornutos1046053cornutos
cortin82423153c_ortin
cotan71521783c_o_tan
cottons9312193c_ottons
cottony1237253c_ottony
coupons112710563c_oupons
cousin8517163c_ousin
couter84930223c_outer
couth106122493c_out_h
couths115715413c_ouths
crampon1336943crampon
cratons94316033cr_atons
crayon114110003cr_ayon
creatin93618133creatin
creation102816513creation
creator93714443creator
crepon1039943cr_epon
cretin82917913cr_etin
crimson1135643crimson
crocein1138073crocein
croft105622683croft__
crofter12299573crofter
crofts114910593croft_s
crook115217573cro__ok
croons85418423cro__ons
crosstown1452783crosstown
crostini1038293crostini
crostino1038883crostino
crotch133410083cro_tch
crouch133910203crou_ch
croup95616783crou__p
croupe105114433crou_pe
croupes114613103croupes
croupous1245923croupous
croups104312553crou_ps
croupy13458733crou_py
crouse84619373crou_se
crown105620083cro__wn
cruor7310453cr_u_or
crutch13408243cr_utch
cryotron1344373cryotron
crypto13367273crypto_
cryptos14337213cryptos
cutin75022783c__utin
cyton101511463c__yton
dromon939363dro_mon
drouth104410103drout_h
drouths11436483drouths
drouthy14395173drouthy
erosion7311123erosion
frontons1136503frontons
futon83113773__futon
grotto7349813grotto_
grottos8337333grottos
grout65330423grout__
grouted94111503grouted
grouter84412523grouter
grouting103410793grouting
grouts75015613grout_s
grouty104710983grout_y
kroon94514483kro__on
krypton1643283krypton
moutons9410313_moutons
muton73817003__muton
photon1111514833pho_ton
pluton838853_pluton
ponton83217643_ponton
proctor11310433proctor
pronto8313993pronto_
protons93118003pro_tons
prounion1046823prounion
prutot8311823pr_utot
puton73617913__puton
ratton64116123_ratton
rhyton12356113_rhyton
ronion63315643_ronion
ronyon9309133_ronyon
roto45935053_ro_to_
rotor55519733_ro_tor
rotos56027883_ro_tos
rotten64115433_rotten
rouen54920903_rou_en
rout46153283_rout__
route55132073_rout_e
routed75624333_routed
router65025843_router
routes66129313_routes
routh86423073_rout_h
rouths95416823_rouths
routine72615903_routine
routing83821093_routing
routs57133413_rout_s
rutin55421343_r_utin
stouten7307333stouten
triton63914893tr_iton
trogon73611753tro_gon
trout57332573trout__
trouts66116633trout_s
trouty95211793trout_y
voudon1035873_voudon
wonton93410963_wonton
youpon11366003_youpon

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.440406115.9
2DLD Change Limit1340271477.14018771.3
3Display Results1471470.0463195.7
 (SQL Overall)1786911477.62623431.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.