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

275 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
manlily123874(None) 
mangily1339751mangily
cannily1239262cannily
dandily12279632dandily
daylily1434982daylily
fancily1538252fancily
handily143610872handily
lankily1437122lankily
manila84518302man_ila
manilla93012472manilla
manille92613272manille
manlier92414022manlier
manlike133012782manlike
manlikely1842052manlikely
manly105022952man__ly
mazily20610392ma_zily
zanily18310182zan_ily
aerily93017013_aerily
airily93014823_airily
ally76935643_a_l_ly
amplify1744083amplify
anality10313633_anality
anally9513503_anally
angrily1137723_angrily
anil46437433_an_il_
anile54634463_an_ile
anility10312723_anility
anils56326723_an_ils
anticly12410053_anticly
anvil82712603_anvil_
anvils9219713_anvils
artily92814713_artily
baggily1436043baggily
baldly12479833ba_ldly
balkily16266693balkily
bally105530103ba_l_ly
balmily14216463balmily
banality1338763banality
banally1249223banally
bawdily1635803bawdily
bonnily1236873bonnily
burlily1237713burlily
cagily12411563ca_gily
calmly1337613ca_lmly
campily1638273campily
candidly1545213candidly
cattily123210853cattily
chancily1845243chancily
crankily1755623crankily
curlily1238383curlily
daffily1735133daffily
daily95922333da__ily
daintily1245523daintily
dally95324743da_l_ly
dandify15245673dandify
dangly114212263dan_gly
dankly14419463dan_kly
dingily1238103dingily
eanling81416673eanling
easily9313023ea_sily
fallibly1644393fallibly
family143311703fa_mily
fancify1834983fancify
fanlike142610503fanlike
fattily13379463fattily
faultily1474523faultily
funkily1736513funkily
funnily1336373funnily
gaily95020973ga__ily
gallfly1433523gallfly
gally95026173ga_l_ly
gamily123712183ga_mily
gangly113911583gan_gly
gassily1137813gassily
gaudily1236523gaudily
gauzily2034393gauzily
gawkily1834093gawkily
godlily1235343godlily
hammily1736063hammily
happily1745763happily
hardily143310273hardily
hastily133010663hastily
hazily2179063ha_zily
holily123612953_holily
jangly174310603jan_gly
jauntily1834173jauntily
jazzily2533373jazzily
jollily1745773jollily
kinkily1335223kinkily
lacily11612763la_cily
lanely93914483lan_ely
lankly13439623lan_kly
lazily1859713la_zily
lily76730183___lily
lonelily1144973lonelily
lowlily1335353lowlily
madly115218133ma__dly
magilp1137613ma_gilp
magnify1634533magnify
mail65543453ma__il_
maile75232223ma__ile
mailing102923343mailing
maill74420793ma__ill
maills84215283mail_ls
mails76037783ma__ils
mainline1039863mainline
mainly11411493ma_inly
majorly1943153majorly
malady1237863ma_lady
malic94525663ma_li_c
malice104818483ma_lice
malign939853ma_lign
malignly1444683ma_lignly
maline84529083ma_line
mall64639373ma_l_l_
malling103623663malling
malls76233433ma_l_ls
malmy124816343ma_l_my
malty106721703ma_l_ty
manacle11310283manacle
manciple1445093manciple
mandala10310213mandala
mandible1337543mandible
mandola1039023mandola
mandril1049353mandril_
mandrill1146613mandrill
mandrils1138493mandrils
manful11610213manful_
manfully1645653manfully
mangaby1535353mangaby
mangel94017533mangel_
mangels103614493mangels
mangey123614523man_gey
mangier104114063mangier
mangle93921323man_gle
mangling122312623mangling
mangold1137213mangold
mangy115021243man__gy
manhole12311343manhole
mania75634153man_i_a
maniac103917973man_iac
manias84029033man_ias
manic94629443man_i_c
manics103919933man_ics
manilas93915873manilas
manillas102611163manillas
manilles102312603manilles
manioc103914823man_ioc
maniple11249653maniple
manito8518693man_ito
manitu8315823man_itu
mankind1437773mankind
manless93012933manless
manliest102314943manliest
mannerly1344983mannerly
manning103616383manning
mannish121710693mannish
mannishly1744113mannishly
mannite9312903mannite
mansion9611543mansion
mantel84317973mantel_
mantels94515043mantels
mantic104120903manti_c
mantid93820383manti_d
mantids103113623mantids
mantilla1048163mantilla
mantis83926033manti_s
mantle84420923man_tle
mantling112012613mantling
manual8313463manual_
manually1347043manually
manuals9311213manuals
manuary1237773manuary
manwise1239183manwise
many95731863man___y
maplike15299273maplike
maquila1844703maquila
marbly134111933ma_rbly
marlier92614773marlier
marlin84220903marli_n
marline93320953marline
marling103322763marling
marlins93420473marlins
marlite92917073marlite
marly106925613ma__rly
maudlinly1561833maudlinly
mauling103315683mauling
maxilla16248193maxilla
mayfly1734403ma_yfly
mazedly2234433mazedly
meanly115412043mean__ly
meatily12311093meatily
merrily1238633merrily
messily12298813messily
mildly12318243m_ildly
milkily16216553milkily
minify1439253min_ify
mirkily16266403mirkily
mistily122612343mistily
mollify1555503mollify
molly105222493m_ol_ly
monthly1535673monthly
moodily1358203moodily
moonily1248943moonily
mousily1239393mousily
muckily18277743muckily
muddily1435963muddily
muggily1435103muggily
murkily16287113murkily
mushily152410093mushily
muskily16289043muskily
mussily12279773mussily
mustily123613633mustily
muzzily2045023muzzily
nastily103011033nastily
nattily103610323nattily
noily86120993__noily
nonoily1049543nonoily
oilily93111723_oilily
palely11311933pa_lely
pallidly1444063pallidly
pally105727123pa_l_ly
panoply1434713panoply
pantile93918483pantile
pawkily1934203pawkily
punily11311773pun_ily
racily11715173ra_cily
rainily10310433rainily
rally84725903ra_l_ly
rancidly1444433rancidly
rankly133910453ran_kly
salify12311373sa_lify
sally85129713sa_l_ly
saltily10310543saltily
sandfly1435643sandfly
sanely93114613san_ely
sanity9316203san_ity
sappily1437163sappily
sassily1038723sassily
saucily1237913saucily
savvily1634323savvily
scantily1337583scantily
sillily10209783sillily
slangily1235383slangily
slily85820033__slily
smarmily1543523smarmily
snakily1436913snakily
sunnily1037833sunnily
surlily10310003surlily
swankily1833833swankily
tackily1637503tackily
tally84526863ta_l_ly
tangibly1444673tangibly
tangly104413913tan_gly
tantivy1335563tantivy
tardily11269583tardily
tartily103511573tartily
tastily103311643tastily
tattily10409993tattily
tawnily1335443tawnily
tinily94014433tin_ily
tinnily1047363tinnily
uglily1036193_uglily
validly1435573va_lidly
vanilla10238743vanilla
vanity12311933van_ity
wackily1936053wackily
wally114625093wa_l_ly
wanly115118023wan__ly
warily122915093wa_rily
waspily1535513waspily
wavily15219483wa_vily
waxily19218413wa_xily
wilily123310763_wilily
windily1437943windily

Search took 9 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272757.76617258.2
3Display Results2752750.0932957.0
 (SQL Overall)1786912758.24921662.1
 
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.