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

278 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
mosts7602854(None) 
costs77231141costs
hosts85526701hosts
masts77035761masts
mists76633901mists
moats75827641moats
molts76032091molts
moots75831661moots
morts75533561morts
mosks116117001mosks
moss67641031mos_s
most66554201most_
moste75925081moste
mots66853161mo_ts
motts76527001motts
musts75527441musts
posts75228781posts
basts75936932basts
bests75932612bests
boasts85017922boasts
boats75635152boats
bolts76232112bolts
boosts86115012boosts
boots75837972boots
borts76735452borts
bosks115218852bosks
boss65938342bos_s
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
busts75227692busts
casts77237792casts
cists76624532cists
coasts85719132coasts
coats75634992coats
colts76633292colts
coots75636842coots
coses76949492coses
cosets85824402cosets
coss66143492cos_s
cost68057942cost_
costa75523732costa
cots68054842co_ts
cysts105912772cysts
doats65224882doats
doits66223672doits
dolts65626312dolts
doses65938502doses
doss56235042dos_s
dost57248352dost_
dots55647662do_ts
dusts65923562dusts
easts57530322easts
fasts86429682fasts
fests85828042fests
fists85527542fists
foists95413982foists
fonts86124752fonts
foots85528282foots
forts86034452forts
foss76431642fos_s
frosts94214622frosts
gasts66628632gasts
gests66028812gests
ghosts10489272ghosts
gists66026192gists
glosts74513812glosts
goats65527302goats
gouts64826172gouts
gusts65722792gusts
hests85829932hests
hists86328372hists
hoists95516022hoists
holts85627912holts
hoots84830242hoots
horsts95817512horsts
hoses85443172hoses
host77852832host_
hosta85917832hosta
hostas94515822hostas
hots78349322ho_ts
imposts11269002imposts
jests125922452jests
joists134711032joists
jolts125018882jolts
joss115925592jos_s
jots116336142jo_ts
jousts135011272jousts
justs124918262justs
kists95822112kists
koss85224812kos_s
lasts57731262lasts
lists56628692lists
lofts85518362lofts
loots55431422loots
loses56742012loses
loss45337962los_s
lost47951492lost_
lots47652092lo_ts
louts56330272louts
lusts55022802lusts
maists85817572maists
malts76331752malts
marts77442232marts
masas75630412masas
masks115320532masks
mass66044932mas_s
mast65959952mast_
mats65460282m_ats
matts76829182matts
mauts75927192mauts
meats75034052meats
meets74224612meets
melts74930102melts
mesas76823202mesas
mess65932432mes_s
midsts95510052midsts
milts75430712milts
mints76834042mints
mioses84318852mioses
miosis83615162miosis
mises74740562mises
misos76523292misos
miss65339412mis_s
mist66154522mist_
misty106120452misty
mitts75523752mitts
moans74624362moans
moas65545342mo_as
moat66352032moat_
mobs85737362mo_bs
mocks135023822mocks
mocs85834902mo_cs
modes85537412modes
mods77945052mo_ds
modus85417202modus
mogs75439332mo_gs
moils76125742moils
moist76033572moist_
mojos145314462mojos
mokes114631032mokes
molas75132092molas
molds85324832molds
moles74747922moles
molests93311562molests
molls75129782molls
mols65948572mo_ls
molt66356162molt_
molto75619602molto
momes95134472momes
moms86539482mo_ms
momus96116112momus
monas74732152monas
monists93614782monists
monks116123392monks
monos75930862monos
mons68152252mo_ns
monte75829772monte
montes84226932montes
month104818422month
months113812932months
moods85224622moods
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302mo_os
moot67653622moot_
mopes95134982mopes
mops85940132mo_ps
moras76438762moras
mores76249642mores
morns75527442morns
mors65950062mo_rs
mort66758832mort_
mos57067122mo__s
mosey105922872mosey
moseys114711702moseys
mosh95227602mos_h
moshes115222872moshes
mosk105622442mos_k
mosses85527682mosses
mosso74715182mosso
mossy105217062mossy
mostest9314792mostest
mostly113110942mostly
mot57279422mo_t_
mote67048082mo_te
motes75944002motes
motets84216192motets
moth96731332mo_th
moths106021552moths
mott66648442mo_tt
motte75526972motte
mottes85523692mottes
motto76119512motto
mottos84615242mottos
moues75732842moues
moults84713702moults
mounts84115072mounts
mouses85531422mouses
mouth105420292mouth
mouths115214532mouths
moves106128422moves
mows96340832mo_ws
moxas145014392moxas
mozos165516332mozos
muses75134302muses
musks116119642musks
muss64933762mus_s
must65145442must_
musth105314782musth
musths11589482musths
musty105620952musty
muts64839982m_uts
mutts75120252mutts
myoses114013842myoses
myosis114012552myosis
mysosts1234542mysosts
nests55728002nests
noses55435642noses
nowts86915852nowts
oasts56529182oasts
oats46554212_oats
omits75018252omits
oots46446442_oots
opts68124742_opts
orts46538332_orts
oses46641512_oses
ousts55225702ousts
outs45746962_outs
pasts75936502pasts
pests75933272pests
poets76024442poets
ports75934592ports
poses74642762poses
posits85718712posits
post67953362post_
pots66452362po_ts
pouts75530322pouts
rests54935872rests
roasts64915412roasts
roosts64916322roosts
roots55933672roots
roses56445772roses
rosets65819952rosets
rots46454092ro_ts
rousts617016722rousts
routs57133412routs
rusts55026992rusts
smolts84411882smolts
softs85019232softs
soots55536202soots
sorts54536662sorts
sots45552442so_ts
tests56530192tests
toasts65914992toasts
tofts84919242tofts
toits55327472toits
toots55331872toots
torts56138122torts
toss45637972tos_s
tost48351922tost_
tots46654122to_ts
touts54830392touts
utmosts934592utmosts
vasts86423772vasts
vests85325982vests
volts85421292volts
wasts87433672wasts
wests85727002wests
wists86728522wists
wonts87621542wonts
worsts96014332worsts
worts88631182worts
wost76544362wost_
wots76342892wo_ts
xysts15558122xysts
zests145419742zests

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 Limit538002781.78030224.7
3Display Results2782780.0634412.7
 (SQL Overall)1786912781.93692299.1
 
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.