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
sooth8592405(None) 
booth105522011booth
sloth85019441sloth
smooth11259191smooth
soot45761051soot_
soothe94214841soothe
sooths95715581sooths
soots55536201soots
sooty84924831sooty
soth75932511s_oth
south85223571south
tooth88020181tooth
azoth17389902azoth
boot67759372boot_
booths115313792booths
boots75837972boots
booty106125912booty
both96533432_both
broth106521092broth
cloth105817542cloth
cooch124916832cooch
coolth1139512coolth
coot67860382coot_
coots75636842coots
couth106122482couth
doeth9411982doeth
doth86225712_doth
foot76248012foot_
foots85528282foots
footy115820532footy
forth116222672forth
froth115919282froth
goth86825082_goth
hooch135813702hooch
hoot75752092hoot_
hootch14386402hootch
hoots84830242hoots
hooty115022432hooty
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
scoot75729142scoot_
scootch1434452scootch
scoots85315932scoots
scot66242602scot_
scotch13207512scotch
scots74025902scots
scouth115011152scouth
shoot84235892shoot_
shoots94619342shoots
shot76150242shot_
shote85526082shote
shots84730832shots
shott85332172shott
sith75435152s_ith
sixth155512232sixth
skosh12407262skosh
slosh84514482slosh
slot46049822slot_
sloths94911882sloths
slots54830522slots
smith107818042smith
smooch13266802smooch
smoosh11236732smoosh
smooths12216312smooths
smoothy15205072smoothy
smote75820272smote
snath86419802snath
snoot55030132snoot_
snoots64216662snoots
snooty94211502snooty
snot44745442snot_
snots55225102snots
soft76942822soft_
softa86415182softa
softs85019232softs
softy115414482softy
sooey84522432sooey
sook84933392soo_k
sooks94425452sooks
soon46240502soo_n
sooted73922582sooted
soothed113712732soothed
soother104215032soother
soothes103917102soothes
soothly13186912soothly
soph97024202s_oph
sort46264812sort_
sorta57125412sorta
sorts54536662sorts
sot310384292s_ot_
soths86218622s_oths
sotol54917642sotol
sots45552442s_ots
sough95320462sough
souths95216602souths
spot65540682spot_
spots74424102spots
stot46347322stot_
stots54828542stots
stott56929782stott
swath115920382swath
swith115917402swith
swoosh12195212swoosh
swot75134652swot_
swots85518422swots
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.0931921408.6
2DLD Change Limit538001402.22024234.2
3Display Results1401400.0463043.5
 (SQL Overall)1786911402.35975748.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.