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

105 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
crunode103471(None) 
crunodes1144971crunodes
crude86018572cru__de
crunodal1142912crunodal
crusade1036052crusade
acnode938203_acnode
anode65021043__anode
arenose7311373arenose
canoe75627253c_ano_e
canoed94618963c_anoed
caruncle1244713caruncle
cathode1338993cathode
cenote83715843c_enote
cestode1037963cestode
chinone12510153chinone
chunked17428213chunked
cladode1134613cladode
clunked14439573clunked
code77347733c___ode
commode1438123commode
connote9311613connote
corrode101310573corrode
coude85022633cou__de
counted103815803counted
couvade1335063couvade
crane75331603cran__e
craned96121653craned_
cranked143812843cranked
crankle133610063crankle
crannoge1144263crannoge
crenate93317113crenate
creole8913733cr_eole
cringe93515483crin_ge
cringed113312403cringed
cringle103010353cringle
crinite9513633crinite
crinkle13359413crinkle
crinoid1039943crinoid
crinoids1147363crinoids
crone75231333cr__one
crooned103813343crooned
crore74922873cr__ore
croze164719453cr__oze
crud75219613cru__d_
crudded1235733cru_dded
cruddy1334193cru_ddy
cruder95612383cru__der
crudes96218623cru__des
cruds85815853cru__ds
cruise84314043cru_ise
cruised103710213cruised
crumbed14378473crumbed
crumble133410403crumble
crummie1336153crummie
crumped144311223crumped
crumple13368363crumple
crunch13349503crun_ch
crunched16328163crunched
cruncher15338073cruncher
crunches153711353crunches
crunchy17324763crunchy
cruor7310453cru_o_r
cruors838643cru_ors
crusaded1244233crusaded
crusader1144273crusader
crusades1146333crusades
crusado1043923crusado
cruse75726103cru__se
crushed134111963crushed
crusted103712753crusted
crustose1045503crustose
cruzado1941943cruzado
cyanide13298843cyanide
dynode1135023_dynode
erode64520993er__ode
grenade938413grenade
grumose1035723grumose
grunge8359583grun_ge
grunted9339283grunted
gruntle8257053gruntle
node513036883___node
precode12311853precode
prude84615973pru__de
pruinose1044853pruinose
prune75119633prun__e
pruned93413113pruned_
recode93618713_recode
rode55844303_r__ode
rude55632783_ru__de
rugose737283_rugose
rundle73214233_rundle
rune45236293_run__e
runkle103611543_runkle
runoff1235413_runoff
runout6414873_runout
runover1034663_runover
tacnode1045093tacnode
threnode1255423threnode
triode75311893tr_iode
trode65322853tr__ode
trundle8307873trundle
trunked12358413trunked
unde55825483__un_de
uranide82212093uranide
urinose738483urinose

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 Limit1340271057.06318975.9
3Display Results1051050.0333181.8
 (SQL Overall)1786911057.51623774.7
 
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.