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

177 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
soths8621863(None) 
goths96513001goths
moths106021551moths
sloths94911891sloths
sooths95715591sooths
sophs104916021sophs
soth75932521soth_
sots45552451sot_s
souths95216601souths
azoths18366202azoths
baths105922922baths
beths105519222beths
booths115313792booths
botas75328782botas
both96533432both_
bothy136713962bothy
bots66453952bot_s
botts75224862botts
broths115013922broths
cloths115512482cloths
cotes76347842cotes
cots68054842cot_s
couths115715412couths
dotes65836692dotes
doth86225712doth_
dots55647662dot_s
eths76619522_eths
froths125411442froths
goth86825082goth_
heths116317782heths
hots78349332hot_s
iotas54821112iotas
jotas125717442jotas
jots116336142jot_s
kiths125814982kiths
kophs145010932kophs
kotos95717702kotos
laths86022402laths
lochs106715512lochs
lotahs9479872lotahs
lotas55926302lotas
loth76132132loth_
lotos54724632lotos
lots47652092lot_s
lotus55718062lotus
maths105624022maths
meths105320232meths
months113812932months
motes75944002motes
moth96731332moth_
mothy136214552mothy
mots66853162mot_s
motts76527002motts
mouths115214532mouths
myths135911602myths
norths96812322norths
notes55034582notes
oaths86117312oaths
ohs66232312_o_hs
oohs75220692_oohs
oots46446442oot_s
paths105521382paths
piths105817542piths
poohs103915712poohs
pothos114214692pothos
pots66452362pot_s
qophs19507812qophs
rotas54827722rotas
rotes56143902rotes
rotis56327062rotis
rotls55620162rotls
rotos56027882rotos
rots46454092rot_s
rouths95416822rouths
rowths12458172rowths
ruths85714642ruths
sates54949322sates
satis55633682satis
scots74025912scot_s
scouths12527892scouths
sets45549502set_s
setts55124322setts
shahs115919512shahs
shotes95321912shotes
shots84730852shot_s
shotts93614702shotts
sighs95416742sighs
sinhs86719602sinhs
sites56045432sites
sith75435162sith_
sits45050212sit_s
situs55019232situs
sixths16416372sixths
sloth85019452sloth_
slots54830532slot_s
smiths114711022smiths
smooths12216322smooths
snaths95112912snaths
snots55225122snot_s
soaks95220292soaks
soaps75120712soaps
soars54732512soars
sobas74424252sobas
sobs64941752so_bs
socas74026182socas
socks114926082socks
sodas64123542sodas
sods54940222so_ds
sofas85320712sofas
softas94410402softas
softs85019232softs
soils55327982soils
sojas124716392sojas
sokes95031422sokes
soles55547922soles
solos54830792solos
sols45448162so_ls
solus54726982solus
somas76030372somas
soms66239372so_ms
sones55444142sones
songs67725552songs
sons46049552so_ns
sooks94425452sooks
sooth85924062sooth_
soothe94214852soothe
soothes103917112soothes
soots55536212soots
soph97024202soph_
sophy136611762sophy
sops65244562so_ps
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028422sorns
sorts54536662sorts
sorus54527582sorus
sos37761602so__s
sot310384302sot__
sotol54917652sotol
sotols63714472sotols
soughs105115622soughs
souks94820522souks
souls55127362souls
soups75322942soups
sours55230502sours
sous46947212so_us
south85223572south_
sows75342492so_ws
soyas84520912soyas
soys75233932so_ys
spots74424112spot_s
stoas55126022stoas
stobs75718232stobs
stops74827282stops
stoss54316342stoss
stots54828552stots
stotts64612862stotts
stows86622702stows
sughs95313322sughs
swaths125312642swaths
swots85518432swot_s
synths12377882synths
syphs13519452syphs
teths85418512teths
tooths96013802tooths
tophs105220052tophs
totes55139682totes
tots46654122tot_s
troths95414152troths
votes84627082votes
worths127812892worths
wots76342892wot_s
yodhs12669012yodhs
yoghs125410592yoghs
youths124510042youths

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.300595636.7
2DLD Change Limit538001771.90628226.7
3Display Results1771770.0463847.8
 (SQL Overall)1786911772.25279347.7
 
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.