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

107 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
dhole9521536(None) 
dholes104914791dholes
dole56550001d_ole
hole77553391_hole
thole85620841thole
whole114418091whole
ahold94714252ahold
amole75724592amole
anole55330382anole
azole145118032azole
bole66448692_bole
chile105626892chile
choke145118022choke
chola104718032chola
choler113717152choler
cholo105217972cholo
chore105126762chore
chose105925402chose
chyle134913482chyle
cole66956112_cole
dale55643982d_ale
dele56843082d_ele
dhal86719282dhal_
dhals95415442dhals
dhobi1136972dhobi
dhooly13457142dhooly
dhoti9310122dhoti
dhow116614002dho_w
dhows125911222dhows
diode74716122diode
diol57329142diol_
diols65521012diols
dipole91112852dipole
doe47361952d_o_e
doge66233802d_oge
dol47150652d_ol_
dolce85816682d_olce
doled75430912d_oled
doles67843752d_oles
doll56632492d_oll
dols56943052d_ols
dolt56649422d_olt
dome77240732d_ome
done55747912d_one
doodle83212852doodle
doolee73018952doolee
doolie73916832doolie
dooly94821802dooly
dope76038892d_ope
dore56353302d_ore
dose56442432d_ose
dote55442882d_ote
dove85131562d_ove
doze145829082d_oze
droll65415402droll
drone65324982drone
drove95518062drove
duple85315862duple
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
mudhole1344912mudhole
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
whale115517432whale
while115418692while
wholes124616772wholes
whore116018042whore
whose114914532whose

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.313570897.8
2DLD Change Limit538001071.53335094.6
3Display Results1071070.0303566.7
 (SQL Overall)1786911071.87695251.1
 
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.