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

168 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
micklest1621912(None) 
ficklest17267901ficklest
mickles153415001mickles_
dickiest153412502dickiest
ickiest133611042_ickiest
kickiest13319672kickiest
mackles154415752mackles_
mickle143715132mickle__
mickler153310232mickle_r
milkiest142911082milkiest
milkless1434772milkless
mirkest13309722mirk_est
mirkiest142910252mirkiest
muckiest163210912muckiest
muckles153413252muckles_
nickles133713822nickles_
pickiest162712592pickiest
pickles153215442pickles_
sickest131813792sick_est
sickles133417542sickles_
sickliest1547522sickliest
tickles133416852tickles_
wickless1736082wickless
backless162910633backless
backlist16910653backlist
backrest1639393backrest
brickiest1737433brickiest
brickles162810283brickles_
buckles153416093buckles_
cackles153717203cackles_
clickless1743983clickless
cockiest163013293cockiest
cockles153414643cockles_
deckles143312803deckles_
diciest103316523dic_iest
dickies143416343dickies_
dictiest113212783dictiest
dinkiest133812873dinkiest
duckiest153211863duckiest
feckless17225783feckless
fickle153912973fickle__
fickler16348423fickle_r
hackles162917063hackles_
hackliest1836523hackliest
heckles163711383heckles_
hickies163614743hickies_
hinkiest153311753hinkiest
huckles163612623huckles_
iceless9219963_iceless
iciest82914743_ic_iest
idlest74014863_i_dlest
illest63615723_i_llest
inkiest113415043_inkiest
inkles103515653_inkles_
inkless11348713_inkless
keckles12318763keckles_
kinkiest113110503kinkiest
kittlest12297573kittlest
likest104914383li_k_est
littlest8309243littlest
luckiest143011443luckiest
luckless14265893luckless
mackle143716433mackle__
mackled164111923mackle_d
macles107023223mac_les_
macules114015133macules_
meekest1336893meek_est
micelles1288833micelles_
micells11107683micells_
miches134320733mic_hes_
mickey174211853mick_e_y
mickeys18447943mick_eys
micks135525373mick__s_
middles113415303middles_
midlist10312513mi_dlist
miffiest1637143miffiest
miggles113512033miggles_
mikes115129893mi_k_es_
mildest102812063mi_ldest
miles74645073mi__les_
milles84526563mi_lles_
millet84030743mi_lle_t
millets94216843mi_llets
miltiest103015173miltiest
minciest122913113minciest
mindless11319443mindless
mingiest113315823mingiest
mingles103719003mingles_
minkes124618783mink_es_
mintiest103217143mintiest
minutest10247653minutest
miriest93619823mi_riest
miskept1538923misk_ept
mistiest103018313mistiest
mitiest93520053mi_tiest
mizzles17329493mizzles_
molest85022743m__olest
muckle143413583muckle__
murkest133110203murk_est
murkiest143210273murkiest
muskiest143311563muskiest
myceles1435213myceles_
neckless14236433neckless
nicest82315663nic__est
nickels13338653nickels_
nickle123814483nickle__
nickled144010443nickle_d
nimblest1236923nimblest
peckiest162711393peckiest
picket144924313pick_e_t
pickets154314183pick_ets
pickle144215653pickle__
pickled164011883pickle_d
pinkest132812623pink_est
pockiest163412053pockiest
prickiest1748183prickiest
prickles162511103prickles_
prickliest1845293prickliest
quickest2345343quick_est
reckless14257973reckless
richest122813683ric_hest
rickets134915093rick_ets
riskiest12310133riskiest
riskless1235763riskless
rockiest142912223rockiest
rockless14297293rockless
ruckles133414603ruckles_
sickees134514213sickees_
sickies133717503sickies_
sickle124418323sickle__
sickled144713433sickle_d
sicklies14710013sicklies_
sickness1437833sickness
silkiest123212853silkiest
simplest122310223simplest
slickest14229253slick_est
smirkiest1535193smirkiest
sockless14267793sockless
stickiest15229603stickiest
stickles142512103stickles_
suckiest143314113suckiest
suckles134516743suckles_
suckless14288823suckless
tackiest143112433tackiest
tackles133816523tackles_
tackless14419483tackless
thickest17337303thick_est
ticket124524853tick_e_t
tickets134113683tick_ets
tickle124616743tickle__
tickled144313133tickle_d
tickler133612653tickle_r
ticklers14339303ticklers
ticklish1755283ticklish
tinkles113713923tinkles_
tinkliest1336133tinkliest
trickiest1549023trickiest
trickles143013763trickles_
trickliest1646433trickliest
viceless1337983viceless
vilest9416843vi__lest
wackest164710863wack_est
wackiest172610273wackiest
wickedest1943463wickedest
wicket155318943wick_e_t
wickets164010943wick_ets
winkles143412773winkles_
yuckiest17328833yuckiest

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.436409841.7
2DLD Change Limit1461621687.22020244.0
3Display Results1681680.0632666.7
 (SQL Overall)1786911687.71923149.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.