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

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

116 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
whole11441809(None) 
dhole95215361dhole
hole77553391_hole
thole85620841thole
whale115517431whale
while115418691while
wholes124616771wholes
whore116018041whore
whose114914531whose
ahold94714252ahold
amole75724592amole
anole55330382anole
awhile1257792awhile
azole145118032azole
bole66448692_bole
chile105626892chile
choke145118022choke
chola104718032chola
choler113717152choler
cholo105217972cholo
chore105126762chore
chose105925402chose
chyle134913482chyle
cole66956112_cole
dholes104914792dholes
dole56550002_dole
hale76052832_hale
haole84820082haole
hoe67562722_ho_e
hoke115935932_hoke
hold86235062_hold
holed95634132_holed
holes84748652_holes
holey115626902_holey
holk116027942_holk
holm95628112_holm
holp95727552_holp
hols76946292_hols
holt77852582_holt
holy106333432_holy
home98042442_home
hone77549322_hone
hope96639672_hope
hose76547242_hose
hove107132222_hove
howe106734102_howe
hoyle11314412_hoyle
jole117233822_jole
mole66251832_mole
obole75917142obole
ole37155212__ole
phone105621932phone
phyle134111152phyle
pole65951302_pole
prole74527792prole
role45851822_role
shale85332832shale
shoe75933442sho_e
shone83725982shone
shore85432652shore
shote85526102shote
shove114421042shove
sole46053672_sole
stole54928812stole
tholed105113872tholed
tholes94919782tholes
those85218142those
tole46052902_tole
vole75236982_vole
wale74546432w_ale
whaled134612032whaled
whaler124611972whaler
whales124716942whales
whee105429592wh_ee
wheel115515332wheel
whelk154311062whelk
whelm134611982whelm
whelp136012092whelp
where117019422where
whiled134514132whiled
whiles124418012whiles
whine116022812whine
white114920302white
who95526772who__
whoa106615202who_a
wholly15366572wholly
whom127018182who_m
whomp155011322whomp
whoof144612692whoof
whoop134211442whoop
whop125520922who_p
whops135013932whops
whored135512122whored
whores125617102whores
whorl114612452whorl
whorled14366902whorled
whorls124410162whorls
whort114623692whort
whortle13335942whortle
whoso11509222whoso
wile75944372w_ile
woe66651242w_o_e
woke115527962w_oke
wold85429072w_old
wolf105729562w_olf
wool76427372wool_
wooled103715502wooled
woolen93111372woolen
wooler93615872wooler
woolie93514482woolie
wools84421462wools
wooly114417672wooly
wore77144672w_ore
wove105624312w_ove
wrote84717482wrote
wyle105519382w_yle

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538001161.45337026.8
3Display Results1161160.0333515.2
 (SQL Overall)1786911161.79699493.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.