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

290 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
doats6522488(None) 
boats75635151boats
coats75635001coats
doat56947671doat_
doits66223671doits
dolts65626311dolts
dots55647661do_ts
drats66628371drats
goats65527301goats
moats75827641moats
oats46554211_oats
adopts998082adopts
bats66962332_bats
beats76042242beats
blats75132502blats
bloats85215762bloats
boars75229602boars
boarts84716872boarts
boas66150832boa_s
boast75935702boast
boasts85017922boasts
boat66360312boat_
bolts76232112bolts
boots75837972boots
borts76735452borts
botas75328782botas
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
brats75336012brats
cats66356342_cats
chats105730092chats
coacts105314332coacts
coals76129602coals
coapts104614012coapts
coast75236272coast
coasts85719142coasts
coat67558352coat_
coati75624642coati
coatis85122602coatis
colts76633292colts
coots75636842coots
costs77231142costs
cots68054842co_ts
dabs77139402d_abs
dads67442772d_ads
dags66642602d_ags
dahs88231812d_ahs
dais57040702d_ais
daks97130602d_aks
dals57145122d_als
dams77444372d_ams
dans56748152d_ans
daps77239162d_aps
darts67635732darts
data56026652d_ata
date56443322d_ate
dates65639152d_ates
dato56129942d_ato
datos65222782d_atos
dauts67822242dauts
daws86638242d_aws
dawts97216122dawts
days87637132d_ays
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
death94822522death
deaths105914442deaths
debts86418372debts
deets65330242deets
defats105114552defats
delts65731792delts
dents65031802dents
derats74625062derats
dhaks13479702dhaks
dhals95415442dhals
dials64925342dials
diets66026642diets
dints67431312dints
dirts66824462dirts
ditas65923672ditas
dits56450522d_its
doated84118182doated
docks126022312docks
docs75631152do_cs
dodos75819392dodos
doers65225712doers
does56554472do_es
doest65829522doest
doeth9411982doeth
doffs125614332doffs
doges75630162doges
dogs66440152do_gs
doit56347852doit_
dojos135111792dojos
doles67843752doles
dolls66126922dolls
dols56943052do_ls
dolt56649422dolt_
domes85735562domes
doms76239572do_ms
donas65926472donas
donate73619502donate
donates83217222donates
dongs76525812dongs
dons56048702do_ns
donuts7410582donuts
dooms85321342dooms
doors65022132doors
dopants1038432dopants
dopas85019062dopas
dopes84935042dopes
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602do_rs
dorty96220812dorty
dos48062312do__s
doses65938502doses
doss56235042do_ss
dost57248352dost_
dot47573182do_t_
dotal64919622dotal
dote55442882do_te
dotes65836692dotes
doth86225712do_th
dotty94516102dotty
doty86128222do_ty
doubts968732doubts
doums85417642doums
doves94728152doves
downs94918572downs
dows85941052do_ws
dozes155226302dozes
drabs85119672drabs
drafts105012532drafts
drags75521112drags
drams86025832drams
drat56247832drat_
draws95119372draws
drays95819772drays
droits74314312droits
duads76515342duads
duals65620082duals
ducats95011762ducats
ducts85319892ducts
duets65323882duets
duits65021882duits
dunts65828412dunts
dusts65923562dusts
dyads10549972dyads
eats47054872_eats
fats76252502_fats
feats86432752feats
fiats85324482fiats
flats86429742flats
floats96816252floats
foals85721692foals
foams105017952foams
fonts86124752fonts
foots85528282foots
forts86034452forts
frats86829672frats
gats56753442_gats
ghats95818612ghats
gloats74515422gloats
gnats65217712gnats
goads77022852goads
goals65521292goals
goas55239942goa_s
goat56250832goat_
gouts64826172gouts
groats74816652groats
hats76858252_hats
heats85838402heats
hoars85925552hoars
holts85627912holts
hoots84830252hoots
hosts85526702hosts
hots78349332ho_ts
ikats95311152ikats
iotas54821112iotas
jolts125018882jolts
jotas125717442jotas
jots116336142jo_ts
kats85944332_kats
khats125316012khats
koans95818622koans
koas85635092koa_s
korats105416062korats
kyats125012442kyats
lats45962702_lats
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
loath84918602loath
lofts85518362lofts
loots55431422loots
lotas55926302lotas
lots47652092lo_ts
louts56330272louts
lovats939072lovats
mats65460292_mats
meats75034052meats
moans74624372moans
moas65545342moa_s
moat66352032moat_
molts76032092molts
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
neats55931902neats
nowts86915862nowts
oafs76425262_oafs
oaks86527902_oaks
oars46846032_oars
oast47156322_oast
oasts56529182_oasts
oat39888262_oat_
oath76132152_oath
oaths86117312_oaths
odahs95610082odahs
odas57230262oda_s
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
pats66460852_pats
peats76140192peats
plats75531372plats
poets76024442poets
ports75934592ports
posts75228782posts
pots66452362po_ts
pouts75530322pouts
prats76333392prats
qats135331342_qats
rats46260372_rats
roads66523622roads
roams74919612roams
roans54926442roans
roars55622242roars
roast56230142roast
roasts64915412roasts
roots55933672roots
rotas54827722rotas
rots46454092ro_ts
routs57133412routs
scats75930602scats
seats54844342seats
shoats94117082shoats
skats94621542skats
slats55436902slats
soaks95220292soaks
soaps75120712soaps
soars54732512soars
softs85019232softs
soots55536212soots
sorts54536662sorts
sots45552452so_ts
spats75031382spats
stats55933362stats
stoats65117482stoats
swats85726862swats
tats46858132_tats
teats55636812teats
toads65621072toads
toast55831012toast
toasts65914992toasts
tofts84919242tofts
toits55327472toits
toots55331872toots
torts56138122torts
tots46654122to_ts
touts54830392touts
twats86616602twats
vats76841742_vats
volts85421292volts
wats77555882_wats
whats117718992whats
woads94818442woads
wonts87621542wonts
worts88631182worts
wots76342892wo_ts

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.296603685.8
2DLD Change Limit538002901.59633709.3
3Display Results2902900.0763815.8
 (SQL Overall)1786912901.96890798.3
 
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.