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

295 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
moats7582764(None) 
boats75635151boats
coats75634991coats
doats65224881doats
goats65527301goats
mats65460281m_ats
meats75034051meats
moans74624361moans
moas65545341moa_s
moat66352031moat_
molts76032091molts
moots75831661moots
morts75533561morts
mosts76028541mosts
mots66853161mo_ts
motts76527001motts
oats46554211_oats
bats66962332_bats
beats76042242beats
blats75132502blats
bloats85215762bloats
boars75229602boars
boarts84716872boarts
boas66150832boa_s
boast75935702boast
boasts85017922boasts
boat66360312boat_
bolts76232112bolts
boots75837972boots
borts76735452borts
botas75328782botas
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
brats75336012brats
cats66356342_cats
chats105730092chats
coacts105314322coacts
coals76129602coals
coapts104614002coapts
coast75236262coast
coasts85719132coasts
coat67558342coat_
coati75624632coati
coatis85122592coatis
colts76633292colts
coots75636842coots
costs77231142costs
cots68054842co_ts
doat56947672doat_
doits66223672doits
dolts65626312dolts
dots55647662do_ts
drats66628372drats
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
hoars85925542hoars
holts85627912holts
hoots84830242hoots
hosts85526702hosts
hots78349322ho_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
maars74621632maars
macs86742502m_acs
mads76845362m_ads
maes66948392m_aes
mags75444522m_ags
malts76331752malts
manats84623462manats
mans66354532m_ans
maps86141042m_aps
mars66261862m_ars
marts77442232marts
mas58175812m_a_s
mass66044932m_ass
mast65959952m_ast
masts77035762masts
mat58083932m_at_
mate65154212m_ate
mates75251362m_ates
math95437442m_ath
maths105624022m_aths
matt65752652m_att
matts76829182matts
mauts75927192mauts
maws96437132m_aws
mays96940022m_ays
meads85425322meads
meals75933372meals
means75831222means
meat66359602meat_
meatus85112922meatus
meaty107021312meaty
meets74224612meets
melts74930102melts
milts75430712milts
mints76834042mints
mists76633902mists
mitts75523752mitts
moa57249182moa__
moan65832012moa_n
moated94819002moated
mobs85737372mo_bs
mocks135023822mocks
mocs85834902mo_cs
modals93914442modals
modes85537412modes
mods77945052mo_ds
modus85417202modus
mogs75439332mo_gs
moils76125752moils
moist76033582moist
mojos145314462mojos
mokes114631032mokes
molars85517322molars
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mo_ls
molt66356162molt_
molto75619602molto
momes95134472momes
moms86539482mo_ms
momus96116112momus
monads94515302monads
monas74732152monas
monks116123392monks
monos75930862monos
mons68152252mo_ns
monte75829772monte
montes84226932montes
month104818422month
months113812932months
moods85224622moods
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302mo_os
moot67653622moot_
mopes95134982mopes
mops85940132mo_ps
morals85324632morals
moras76438762moras
morass84614492morass
morays114613882morays
mores76249642mores
morns75527442morns
mors65950062mo_rs
mort66758832mort_
mos57067122mo__s
mosks116117002mosks
moss67641032mo_ss
most66554202most_
moste75925082moste
mot57279422mo_t_
mote67048082mo_te
motes75944002motes
motets84216192motets
moth96731332mo_th
moths106021552moths
mott66648442mo_tt
motte75526972motte
mottes85523692mottes
motto76119512motto
mottos84615242mottos
moues75732842moues
moults84713702moults
mounts84115072mounts
mouth105420292mouth
mouths115214532mouths
moves106128422moves
mows96340832mo_ws
moxas145014392moxas
mozos165516332mozos
musts75527442musts
muts64839982m_uts
mutts75120252mutts
neats55931902neats
nowts86915852nowts
oafs76425262_oafs
oaks86527902_oaks
oars46846032_oars
oast47156322_oast
oasts56529182_oasts
oat39888262_oat_
oath76132152_oath
oaths86117312_oaths
omits75018262omits
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
pats66460852_pats
peats76140192peats
plats75531372plats
poets76024442poets
ports75934592ports
posts75228782posts
pots66452362po_ts
pouts75530322pouts
prats76333392prats
qats135331342_qats
rats46260372_rats
roads66523612roads
roams74919612roams
roans54926442roans
roars55622232roars
roast56230142roast
roasts64915412roasts
roots55933672roots
rotas54827722rotas
rots46454092ro_ts
routs57133412routs
scats75930602scats
seats54844342seats
shoats94117072shoats
skats94621532skats
slats55436902slats
smolts84411882smolts
soaks95220292soaks
soaps75120712soaps
soars54732512soars
softs85019232softs
soots55536202soots
sorts54536662sorts
sots45552442so_ts
spats75031382spats
stats55933362stats
stoats65117482stoats
swats85726862swats
tats46858132_tats
teats55636812teats
toads65621062toads
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.0931921408.6
2DLD Change Limit538002951.62633087.3
3Display Results2952950.0763881.6
 (SQL Overall)1786912951.79599549.3
 
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.