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

287 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
molts7603209(None) 
bolts76232111bolts
colts76633291colts
dolts65626311dolts
holts85627911holts
jolts125018881jolts
malts76331751malts
melts74930101melts
milts75430711milts
moats75827641moats
molas75132091molas
molds85324831molds
moles74747921moles
molls75129781molls
mols65948571mol_s
molt66356161molt_
molto75619601molto
moots75831661moots
morts75533561morts
mosts76028541mosts
mots66853161mo_ts
motts76527001motts
moults84713701moults
smolts84411881smolts
volts85421291volts
alts46639902_alts
amoles84122192amoles
belts75931162belts
blots75626172blots
boats75635152boats
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolt66254172bolt_
bolus79125542bolus
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
celts75325782celts
clots75627642clots
coats75634992coats
colas75436772colas
colds85726972colds
coles76055062coles
cols66553082col_s
colt67158242colt_
coots75636842coots
costs77231142costs
cots68054842co_ts
cults75022552cults
delts65731792delts
doats65224882doats
doits66223672doits
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolt56649422dolt_
dots55647662do_ts
felts85324542felts
folds95221692folds
folks126017122folks
fonts86124752fonts
foots85528282foots
forts86034452forts
gelts65924612gelts
gilts64924262gilts
goats65527302goats
golds75421312golds
golfs95616102golfs
gouts64826172gouts
halts85230102halts
hilts86924412hilts
holds94623242holds
holes84748652holes
holks124720562holks
holms105117802holms
hols76946292hol_s
holt77852582holt_
hoots84830242hoots
hosts85526702hosts
hots78349322ho_ts
jilts124717412jilts
joles125230832joles
jolt116639122jolt_
jolty155713032jolty
jots116336142jo_ts
kelts95222632kelts
kilts95122182kilts
kolas94822232kolas
kolos94921212kolos
lilts55822802lilts
lofts85518362lofts
lolls512121732lolls
loots55431422loots
lots47652092lo_ts
louts56330272louts
males75049792males
malls76233432malls
malms95021552malms
malt66254802malt_
malty106721702malty
marts77442232marts
masts77035762masts
mats65460282m_ats
matts76829182matts
mauts75927192mauts
meats75034052meats
meets74224612meets
melds84822382melds
mells75031332mells
mels65941532mel_s
melt65752892melt_
melty104918362melty
milds86422052milds
miles74645072miles
milks115020582milks
mills75435052mills
milos75428012milos
mils66045322mil_s
milt65455802milt_
milty104720072milty
mints76834042mints
mists76633902mists
mitts75523752mitts
moans74624362moans
moas65545342mo_as
moat66352032moat_
mobs85737362mo_bs
mocks135023822mocks
mocs85834902mo_cs
modes85537412modes
mods77945052mo_ds
modus85417202modus
mogs75439332mo_gs
moils76125742moils
moist76033572moist
mojos145314462mojos
mokes114631032mokes
mol56654592mol__
mola66035632mol_a
molal75120342molal
molar75223092molar
molars85517322molars
mold76034332mol_d
moldy115014652moldy
mole66251832mol_e
molest85022742molest
molests93311562molests
molies84429512molies
moll66735702mol_l
molly105222492molly
molted94217472molted
molten83311812molten
molter84119422molter
molters93816972molters
moly96031912mol_y
momes95134472momes
moms86539482mo_ms
momus96116112momus
monas74732152monas
monks116123392monks
monos75930862monos
mons68152252mo_ns
monte75829772monte
montes84226932montes
month104818422month
months113812932months
moods85224622moods
moolas83615592moolas
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302mo_os
moot67653622moot_
mopes95134982mopes
mops85940132mo_ps
moras76438762moras
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
moulds94910992moulds
moult74728722moult_
mounts84115072mounts
mouth105420292mouth
mouths115214532mouths
moves106128422moves
mows96340832mo_ws
moxas145014392moxas
mozos165516332mozos
mulcts10298712mulcts
mules75034292mules
mulls75124152mulls
musts75527442musts
muts64839982m_uts
mutts75120252mutts
nolos54423352nolos
nowts86915852nowts
oats46554212_oats
olds55926572_olds
oles46453472_oles
omits75018252omits
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
pelts76128812pelts
plots75025672plots
poets76024442poets
poles75351002poles
polis74731162polis
polls74627722polls
polos76129902polos
pols66044562pol_s
polys105718752polys
ports75934592ports
posts75228782posts
pots66452362po_ts
poults84613482poults
pouts75530322pouts
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
roots55933672roots
rotls55620162rotls
rots46454092ro_ts
routs57133412routs
salts55431882salts
silts55330822silts
slots54830522slots
smalts85214892smalts
smelts85412772smelts
smolt74824162smolt_
softs85019232softs
soles55547922soles
solos54830792solos
sols45448162sol_s
solus54726982solus
soots55536202soots
sorts54536662sorts
sots45552442so_ts
tilts55325612tilts
tofts84919242tofts
toits55327472toits
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
toots55331872toots
torts56138122torts
tots46654122to_ts
touts54830392touts
voles86234042voles
volt76439532volt_
volta85215622volta
volte85321302volte
voltes94915582voltes
volti84915962volti
welts85225192welts
wilts85023502wilts
wolds95420182wolds
wolfs116214162wolfs
wonts87621542wonts
worts88631182worts
wots76342892wo_ts
yolks125412772yolks

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 Limit538002871.47036598.6
3Display Results2872870.0763776.3
 (SQL Overall)1786912871.639109024.4
 
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.