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

95 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
crunodes114497(None) 
crunode1034711crunode_
crudes96218622cru__des
crunches153711352crunches
crunodal1142912crunodal
crusades1146332crusades
acnodes1037833_acnodes
anodes74418763__anodes
brunches153710453brunches
canoes84725883c_ano_es
caruncles1345013caruncles
cathodes1439393cathodes
cenotes92814543c_enotes
cestodes1138203cestodes
chinones13510483chinones
cladodes1245323cladodes
codes86247293c___odes
commodes1539093commodes
condoes104319203c_ondoes
connotes10311453connotes
corrodes111310333corrodes
counties10316283counties
couvades1435613couvades
cranches153114543cranches
cranes84330753cran__es
crankles143510163crankles
crannies10313013crannies
crannoges1244243crannoges
craunches1655723craunches
creoles9913323cr_eoles
cringes103215503crin_ges
cringles11329473cringles
crinites10612763crinites
crinkles14269173crinkles
crinoids1147383crinoids
crones84729243cr__ones
cronies9622513cron_ies
crores86121163cr__ores
crozes174417663cr__ozes
cruces105117543cru__ces
crudded1235733cru_dded
crude86018573cru__de_
cruder95612383cru__der
crudest104510333cru__dest
crudites1137763crudites
cruds85815853cru__d_s
cruises93514443cru_ises
crumbles14329683crumbles
crummies1437643crummies
crumples14348813crumples
crunched16328163crunched
cruncher15338073cruncher
crunchers16316243crunchers
cruors838643cru_o_rs
crusade1036053crusade_
crusaded1244233crusaded
crusader1144273crusader
crusaders1243453crusaders
crusadoes1243043crusadoes
crusados1153543crusados
cruses88127713cru__ses
crushes124215133cru_shes
crutches15359593crutches
cruxes154911563cru__xes
cruzadoes2141743cruzadoes
cruzados2041973cruzados
custodes1136653custodes
cyanides14258003cyanides
cyanoses1337423cyanoses
dynodes1235453_dynodes
erodes74819883er__odes
grenades1038433grenades
grunges93310403grun_ges
gruntles9287233gruntles
nodes64633493___nodes
precodes13711573precodes
prudes94215443pru__des
prunes83419063prun__es
prunuses1035123prunuses
recodes102918633_recodes
rodes614039083_r__odes
rundles83214713_rundles
runes55530223_run__es
runkles114111943_runkles
runoffs1343013_runoffs
runouts737353_runouts
runover1034663_runover
runovers1134473_runovers
scrunches1635403scrunches
tacnodes1145003tacnodes
threnodes1354963threnodes
triodes84012503tr_iodes
trundles9278483trundles
undoes73917403__undoes
uranides92211283uranides

Search took 9 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.420425454.8
2DLD Change Limit146162957.83018666.9
3Display Results95950.0303166.7
 (SQL Overall)178691958.28021581.0
 
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.