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

187 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
milkily1621655(None) 
mirkily16266401mirkily
silkily14236961silkily
balkily16266692balkily
bulkily16227122bulkily
filmily1535732filmily
ickily1535752_ickily
kinkily1335222kinkily
mildly12318242mil_dly
milkier133411162milkier
milking143712762milking
milky144014442milk__y
mistily122612342mistily
muckily18277742muckily
murkily16287112murkily
muskily16289042muskily
oilily93111722oil_ily
riskily1436412riskily
sillily10209782sillily
smirkily1753332smirkily
sulkily14218112sulkily
wilily123310762wil_ily
airily93014823ai_rily
balmily14216463balmily
bilking144413553bilking
billy105525363bil__ly
chillily1644113chillily
cockily1838493cockily
dilly94923783dil__ly
dingily1238103dingily
dinkly144311083dink_ly
dirtily1138583dirtily
dizzily1934843dizzily
duskily15236753duskily
fickly18318533fick_ly
fierily1339023fierily
filly114424903fil__ly
filthily1743663filthily
fishily1637643fishily
flakily1736293flakily
flukily1735213flukily
folksily1843443folksily
friskily1834503friskily
funkily1736513funkily
gawkily1834093gawkily
giddily1335073giddily
gilly94321633gil__ly
gluily10308293_gluily
guiltily1243423guiltily
hilly114422163hil__ly
hokily16409093_hokily
holily123612953hol_ily
huskily17236333huskily
icily101211693_i_cily
illy76925333_il__ly
jerkily2134623jerkily
jokily20306533_jokily
jollily1745773jollily
joltily1746323joltily
lankily1437123lankily
leakily1436473leakily
likely13328133li_kely
lily76730183__l_ily
luckily16297083luckily
malkin122913153malki_n
malkins133311803malkins
mangily1339753mangily
manlily1238743manlily
mazily20610393m_azily
meatily12311093meatily
meekly1535193meek_ly
merrily1238633merrily
messily12298813messily
mickey174211853mick_ey
mickle143715133mick_le
micrify1744693micrify
mightily1744623mightily
miking134218463mi_king
milady1236613mil_ady
mildewy16353533mildewy
milding113615453milding
milfoil1264383milfoil_
milfoils1343893milfoils
milia72719573mil_i_a
miliary1249463miliary
milieu8314113mil_ieu
milium104712683mil_ium
milk105028473milk___
milked134612573milk_ed
milker124814323milk_er
milkers134411613milkers
milkfish2043333milkfish
milkiest142911083milkiest
milkman1544913milkman
milkmen1565213milkmen
milks115020583milk__s
milksop1542833milksop
mill66541483mil__l_
mille75029133mil__le
milliary1346853milliary
millier93716703millier
millilux1742933millilux
millime112511403millime
milline92519113milline
milling103223683milling
million91813143million
mills75435053mil__ls
miltier93214963miltier
milting103619123milting
milty104720073mil__ty
minify1439253mi_nify
mirkier13319053mirkier
mirky146315523mirk__y
misally121111063misally
misbill1137033misbill
miserly12329823miserly
misfile122611553misfile
miskal123710263miskal_
miskals13369773miskals
miskick1435613miskick
misrely12319613misrely
missile92815403missile
missilry1344653missilry
mixedly2033983mixedly
mizzly19256103mi_zzly
mollify1555503mollify
molly105222493mol__ly
moodily1358203moodily
moonily1248943moonily
mousily1239393mousily
muddily1435963muddily
muggily1435103muggily
multiply15106613multiply
murkly15368303murk_ly
mushily152410093mushily
mussily12279773mussily
mustily123613633mustily
muzzily2045023muzzily
niftily1335753niftily
nippily1444713nippily
pawkily1934203pawkily
perkily1637813perkily
peskily1635083peskily
pinkly155012243pink_ly
pithily1567033pithily
pockily1846233pockily
pokily15309063_pokily
pulpily1436103pulpily
quakily2336693quakily
quirkily2442593quirkily
ritzily1945143ritzily
saltily10310543saltily
shakily1736903shakily
sicklily1744293sicklily
sickly153110483sick_ly
silkie103313403silki_e
silkier114411643silkier
silkies113715693silkies
silking123715593silking
silky125315823silk__y
silly84527623sil__ly
slily85820033_sl_ily
slimily1247713slimily
slinkily1534853slinkily
smokily1635373smokily
snakily1436913snakily
spikily1635873spikily
stalkily1534823stalkily
stickily1736083stickily
tackily1637503tackily
tidily102811393ti_dily
tinily94014433ti_nily
tinkly134811153tink_ly
tinnily1047363tinnily
tipsily1236043tipsily
trickily1736233trickily
uglily1036193ugl_ily
vilely1239443vil_ely
vilify1536773vil_ify
wackily1936053wackily
wildly13328123wil_dly
willy115321913wil__ly
windily1437943windily
wirily123310783wi_rily
wispily1535653wispily
wittily1336173wittily
zinkify2643123zinkify

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271876.95319276.1
3Display Results1871870.0632968.3
 (SQL Overall)1786911877.40624127.9
 
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.