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

224 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
unmilled119785(None) 
unbilled1188691unbilled
unfilled1298381unfilled
untilled9710561untilled
unwilled1277821unwilled
anvilled1236482anvilled
milled94326172__milled
nilled73919452_n_illed
uncalled11810922uncalled
unchilled1545562unchilled
undrilled1146662undrilled
undulled1036992undulled
unfilmed1495802unfilmed
ungalled1078462ungalled
unmailed11229762unmailed
unmelted1169182unmelted
unmined102612952unmi_ned
unmingled1344282unmingled
unmitred1136842unmitred
unmixed17228212unmi_xed
unmolded1237452unmolded
unoiled82415472unoi_led
unpiled102312742unpi_led
unpolled1168942unpolled
unrifled1237422unrifled
unrolled9610412unrolled
unskilled1444602unskilled
unspilled1245092unspilled
untilted9610892untilted
untitled978762untitled
untwilled1343872untwilled
unwalled1288652unwalled
annulled944833annulled
anviled1138943anvi_led
billed94224903__billed
brailled1147193brailled
cavilled1436733cavilled
chilled133310933_chilled
devilled1336743devilled
dilled84122223__dilled
drilled94711673_drilled
enamelled1244613enamelled
engilded1143983engilded
enisled82510223en_isled
enrolled967963enrolled
ensiled82611433ensi_led
entitled967503entitled
filled104922263__filled
frilled113911603_frilled
fulfilled1642693fulfilled
funnelled1374233funnelled
gilled84521633__gilled
grilled94012833_grilled
hilled104022223__hilled
instilled1045293instilled
intitled967343intitled
inwalled1275773inwalled
killed113918773__killed
knelled12338983kn_elled
knolled12296563kn_olled
malled94626113__malled
melled95023023__melled
milded104416153__milded
milked134612573__milked
mille75029133__mille_
miller84625413__miller
milles84526563__milles
millet84030743__millet
milted93919943__milted
misled94719313__misled
mulled94721553__mulled
nailed74021493_nai_led
nulled74318273_n_ulled
outkilled1444753outkilled
outwilled1345013outwilled
pencilled1445643pencilled
perilled11410103perilled
pilled94222753__pilled
prilled104712993_prilled
pummelled1643073pummelled
quilled17329283_quilled
rebilled11318053rebilled
refilled12278673refilled
rilled74525653__rilled
shilled113313623_shilled
shrilled1246863shrilled
skilled123110863_skilled
smelled103511853_smelled
smiled93716433_smi_led
snailed83811923snai_led
snelled83313043sn_elled
spilled103613623_spilled
stilled83314783_stilled
swilled113611833_swilled
thrilled1235493thrilled
tilled74722953__tilled
trilled84116313_trilled
tunnelled1054583tunnelled
twilled11398033_twilled
umbeled12208193u_mbeled
umbelled1336273umbelled
unaided92414603unai_ded
unaimed102812493unai_med
unaired82916013unai_red
unallied938393unallied
unaneled939793unaneled
unbaled103315963un_baled
unbelted1179333unbelted
unbiased1147153unbiased
unbitted1138213unbitted
unboiled112410373unboiled
unbolted1179323unbolted
unbridled1344973unbridled
uncoiled112512683uncoiled
uncooled112710633uncooled
uncurled1168963uncurled
undiluted1144903undiluted
undimmed1434113undimmed
unfallen1144463unfallen
unfelted1279403unfelted
unfired112212453unfi_red
unfished15218293unfished
unfitted1238163unfitted
unfixed18218563unfi_xed
unfoiled12249723unfoiled
unfolded1338313unfolded
unfurled1277203unfurled
ungelded1147403ungelded
ungifted13116833ungifted
ungirded1136083ungirded
unglued937303un_glued
unhailed12219963unhailed
unhalved1556513unhalved
unhealed121511073unhealed
unhelmed1435993unhelmed
unhelped1435923unhelped
unhinged13257473unhinged
unhired112512153unhi_red
unified112413573un_ified
unilobed1136393un_ilobed
unimbued1343073unimbued
united74421543un_i_ted
unkeeled13117183unkeeled
unkindled1594203unkindled
unkinked12215903unkinked
unkissed1334893unkissed
unled64021073un___led
unlicked15248263unlicked
unliked122411283unli_ked
unlined82515803unli_ned
unlinked13237793unlinked
unlisted9311153unlisted
unlived112511373unli_ved
unmanned11268603unmanned
unmapped1535173unmapped
unmarked15248813unmarked
unmarred11258403unmarred
unmasked15267143unmasked
unmated103317023unm_ated
unmatted1138293unmatted
unmellow1342243unmellow
unmended12299093unmended
unmeshed1437003unmeshed
unmewed13258173unm_ewed
unmingle1145913unmingle_
unmingles1243983unmingles
unmiter9310393unmi_ter
unmitered1245853unmitered
unmitre936993unmitre_
unmitres1036863unmitres
unmixes16197753unmi_xes
unmold9148313unm_ol_d
unmolten1044933unmolten
unmoored1137333unmoored
unmoved13248903unm_oved
unmuffled1872343unmuffled
unmuzzled2062063unmuzzled
unnailed9229443unnailed
unpeeled11118533unpeeled
unpicked17237213unpicked
unpile81914323unpi_le_
unpiles92112783unpi_les
unpinned1136383unpinned
unpitied1138793unpitied
unpitted1148623unpitted
unquelled1944413unquelled
unreeled91310333unreeled
unribbed1334173unribbed
unriddled1243813unriddled
unrigged1165643unrigged
unrimed102211633unri_med
unrinsed938383unrinsed
unripped1335763unripped
unrivaled1345243unrivaled
unrivalled1443243unrivalled
unruled8311373un_ruled
unsalted9510923unsalted
unscaled111410113unscaled
unsealed91513623unsealed
unshelled1336563unshelled
unsifted12128773unsifted
unsigned1037563unsigned
unsized172510543unsi_zed
unsliced1138093unsliced
unsoiled92412083unsoiled
unsolved1237833unsolved
unsullied1044543unsullied
untidied1038903untidied
untied73720813unti__ed
untimed102713373unti_med
untinged10308943untinged
untipped1335763untipped
untired82316383unti_red
unvalued1266313unvalued
unveiled1298163unveiled
unwelded1337133unwelded
unwished15237833unwished
unwitted1237543unwitted
unzipped2233213unzipped
uppiled12216593uppi_led
uptilted1174683uptilted
upwelled1434663upwelled
willed104722453__willed
windmilled1751613windmilled

Search took 7 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.1531167915.0
2DLD Change Limit1461622246.22023498.7
3Display Results2242240.0932408.6
 (SQL Overall)1786912246.46627635.5
 
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.