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 “molested” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

196 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
molested1117824(None) 
molester1099371molester
coleseed1147402coleseed
forested12312462forested
modester1197482modester
molest85022742molest__
molesters1198872molesters
molests93311562molest_s
molted94217472mol__ted
unmolested1343782unmolested
alerted82512223_alerted
arrested939153arrested
attested936293attested
bested94922753__bested
bilsted1038033bil_sted
blasted104213473_blasted
bleated104015973_bleated
blessed10319493_blessed
boasted104113743bo_asted
bolete8519613bole_te_
boletes9316063bole_tes
bolster93713423bol_ster
bolted94617803bol__ted
boosted104111983bo_osted
celeste949653celeste_
celestes10310013celestes
chested133811673_chested
cleated103417843_cleated
clefted13326753_clefted
closeted1135613closeted
coalesced1444553coalesced
coasted104015953co_asted
cohosted1436133cohosted
coleseeds1244323coleseeds
colessee1098793colessee
collated113615063collated
collected1447973collected
colleted113011663colleted
congested1338673congested
contested12310693contested
corseted11311473corseted
cosseted1178343cosseted
costed95623113co__sted
coveted133011523cove_ted
crested103416533_crested
deleted93314913dele_ted
delisted10310563delisted
detested10279623detested
devested13239133devested
digested11208163digested
divested13268213divested
dopester1137253dopester
egested938123_egested
elected102812613_elected
enlisted978193enlisted
fileted1159093file_ted
fleeted113310233_fleeted
fleshed143210263_fleshed
foisted113210603fo_isted
foliated1249913foliated
fomented1437803fomented
forester11313673forester
foveated1536293foveated
galeated104111573galeated
gleeted9379323_gleeted
guested9157713_guested
hoisted113411293ho_isted
holster103512213hol_ster
homestead1544023homestead
honester1139713honester
hosted105020343ho__sted
infested12249643infested
ingested10259003ingested
invested12229693invested
isleted837523isle_ted
jested144416503__jested
joisted15379173jo_isted
jokester1934443jokester
jolted143510633jol__ted
jonesed1536263jones_ed
jousted15339143jo_usted
lasted74323603__lasted
letted74118543__letted
listed74322833__listed
lusted74319443__lusted
maleate94117543maleate_
maleates103316343maleates
malted94819863mal__ted
maltster1035303maltster
masted94025803m__asted
meated94222403m__eated
melted94219063m__elted
meshed124415933m__eshed
messed95018183m__essed
mestee84523883m__estee
meted85424433m__e_ted
milkshed1842943milkshed
milted93919943mil__ted
misted93625823m__isted
moated94819003mo__ated
mobster11299213mo_bster
modeled1139463mode_led
modelled1236433modelled
modemed1336723mode_med
moderated1388143moderated
modest93818453modest__
modestest1245003modestest
modesties1247473modesties
modestly14375583modestly
modesty13476983modest_y
modiste1039283modiste_
modistes1138643modistes
mofette1296773mofette_
mofettes1386083mofettes
moisten93110143mo_isten
moister94015373mo_ister
molasses1037233molasses
molded104414083mol__ded
moldered1237173moldered
moles74747923moles___
moleskin1444083moleskin
molesting1237753molesting
molten83311813mol__ten
molter84119423mol__ter
moneyed1337493mone_yed
monished1438133monished
monoester1146453monoester
monster93214603mo_nster
moonseed1154673moonseed
mooted94120373mo__oted
morseled1147193morseled
moseyed1336133mose_yed
moshed124517493mo__shed
mossed94818893mo__ssed
moste75925083mo__ste_
moulted103310313mo_ulted
mounted103611533mo_unted
moused94423303mo_us_ed
moussed10338913mo_ussed
mozette1886773mozette_
mulcted12296693mul_cted
musted93321073m__usted
nested74720063__nested
nonvested1346003nonvested
obtested1135453obtested
oersted839553_oersted
oldster896573_oldster
oleaster837263_oleaster
oleate6318883_oleate_
oleates7417833_oleates
olestra746173_olestra
ousted73720583_o_usted
pileated112711133pileated
pleated103816633_pleated
poleaxed1854823poleaxed
polestar1047113polestar
polished1468433polished
pollster1037103pollster
polluted1135433polluted
polyester1445353polyester
posted93722493po__sted
priested1138393priested
protested12159113protested
quested17168383_quested
reested82916233_reested
relented92614943relented
relisted9312623relisted
renested92212953renested
rested74430783__rested
retested92212533retested
revested122612243revested
roasted83912663ro_asted
roosted83211883ro_osted
rouletted1045053rouletted
rousted84013323ro_usted
selected1159783selected
sklented1335053sklented
sleeted83113223_sleeted
solated83618023sol_ated
solvated12237443solvated
talented938423talented
tested74421523__tested
toasted84011923to_asted
toileted936993toile_ted
tolerated1049123tolerated
unletted9310313unletted
unlisted9311153unlisted
unrested91914513unrested
untested92612413untested
unvested122210223unvested
valeted1139013vale_ted
vested104217353__vested
voluted11297943vol_uted
worsted1138013wo_rsted
wrested113410933_wrested
zested164214043__zested

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621966.56322270.6
3Display Results1961960.0802450.0
 (SQL Overall)1786911967.06325299.6
 
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.