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

140 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
sooth8592406(None) 
booth105522011booth
sloth85019451sloth
smooth11259201smooth
soot45761061soot_
soothe94214851soothe
sooths95715591sooths
soots55536211soots
sooty84924841sooty
soth75932521s_oth
south85223571south
tooth88020181tooth
azoth17389902azoth
boot67759372boot_
booths115313792booths
boots75837972boots
booty106125912booty
both96533432_both
broth106521092broth
cloth105817542cloth
cooch124916832cooch
coolth1139512coolth
coot67860382coot_
coots75636842coots
couth106122492couth
doeth9411982doeth
doth86225712_doth
foot76248012foot_
foots85528282foots
footy115820532footy
forth116222672forth
froth115919282froth
goth86825082_goth
hooch135813702hooch
hoot75752102hoot_
hootch14386412hootch
hoots84830252hoots
hooty115022442hooty
loath84918602loath
loot46955822loot_
loots55431422loots
loth76132132_loth
month104818422month
mooch125313612mooch
moot67653622moot_
moots75831662moots
moth96731332_moth
mouth105420292mouth
north86018272north
oath76132152_oath
ooh67637092_oo_h
oot311274692_oot_
oots46446442_oots
pooch124815302pooch
pooh96027382poo_h
quoth173310352quoth
root45655922root_
roots55933672roots
rooty86423022rooty
routh86423072routh
rowth115713232rowth
saith85826552saith
scooch13228122scooch
scoot75729152scoot_
scootch1434462scootch
scoots85315942scoots
scot66242612scot_
scotch13207522scotch
scots74025912scots
scouth115011152scouth
shoot84235912shoot_
shoots94619362shoots
shot76150262shot_
shote85526102shote
shots84730852shots
shott85332192shott
sith75435152s_ith
sixth155512232sixth
skosh12407272skosh
slosh84514482slosh
slot46049832slot_
sloths94911892sloths
slots54830532slots
smith107818052smith
smooch13266802smooch
smoosh11236732smoosh
smooths12216322smooths
smoothy15205082smoothy
smote75820282smote
snath86419802snath
snoot55030142snoot_
snoots64216682snoots
snooty94211512snooty
snot44745452snot_
snots55225122snots
soft76942822soft_
softa86415182softa
softs85019232softs
softy115414482softy
sooey84522432sooey
sook84933392soo_k
sooks94425452sooks
soon46240502soo_n
sooted73922592sooted
soothed113712742soothed
soother104215042soother
soothes103917112soothes
soothly13186922soothly
soph97024202s_oph
sort46264812sort_
sorta57125412sorta
sorts54536662sorts
sot310384302s_ot_
soths86218632s_oths
sotol54917652sotol
sots45552452s_ots
sough95320462sough
souths95216602souths
spot65540692spot_
spots74424112spots
stot46347332stot_
stots54828552stots
stott56929792stott
swath115920382swath
swith115917402swith
swoosh12195212swoosh
swot75134662swot_
swots85518432swots
synth113711822synth
toot45958882toot_
tooths96013802tooths
toothy12529692toothy
toots55331872toots
toroth95512962toroth
troth85622202troth
woosh113710732woosh
worth117120522worth
wroth116815882wroth
youth115315042youth
zooty175415352zooty

Search took 3 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 Limit538001401.71631352.0
3Display Results1401400.0463043.5
 (SQL Overall)1786911402.07586116.1
 
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.