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

171 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
littlest830924(None) 
kittlest12297571kittlest
littles73212781littles_
bittiest103012042bittiest
brittlest11146192brittlest
fittest102510802fitt_est
kittles113012492kittles_
lintiest82715912lintiest
lintless82710012lintless
listless8269262listless
lithest10513912li_thest
little63312162little__
littler7348552little_r
littlish1145042littlish
nittiest82712602nittiest
slittiest938202slittiest
tittles73413252tittles_
vittles103211112vittles_
wittiest112711522wittiest
attest62618613_att_est
battiest104115553battiest
battles94517683battles_
belittles1143873belittles_
bitsiest102610063bitsiest
bitterest1147713bitterest
blithest1338083bli_thest
blottiest11286833blottiest
bottles94216273bottles_
brittles10178653brittles_
cattiest103016333cattiest
citoles9312553citoles_
cuittles1045903cuittles_
cuttles93613923cuttles_
dictiest113212783dictiest
dirtiest93014203dirtiest
ditsiest92111323ditsiest
ditties83116983ditties_
ditziest18218473ditziest
dottiest92611393dottiest
dottles83912283dottles_
fattest102913063fatt_est
fattiest113514313fattiest
fettles103912733fettles_
ficklest17267903ficklest
flattest1138713flatt_est
flintiest1248433flintiest
flirtiest1236193flirtiest
gentlest93410573gentlest
giftless1245173giftless
glintiest1037623glintiest
glitziest1944003glitziest
grittiest10176983grittiest
guttiest92311223guttiest
guttles83011933guttles_
hiltless11297123hiltless
hitless103211193hi_tless
hottest10411383hott_est
idlest74014863_i_dlest
illest63615723_i_llest
istles62814983_istles_
ixtles13217063_ixtles_
jettiest15359593jettiest
kettles113411613kettles_
kirtles11309663kirtles_
kitties113213623kitties_
kittle104012173kittle__
kittled12388193kittle_d
kittler11338163kittle_r
latest63822703l_at_est
lathiest11312653lathiest
lattes65324203latt_es_
leftest10269463left_est
libelist10310823libelist
lidless8309273li_dless
liefest1038443li_efest
lievest1048343li_evest
lifeless11228143lifeless
lightest121410353lightest
lightless1386073lightless
ligules82210923ligules_
likeliest1346123likeliest
likest104914383li__kest
limbiest12258893limbiest
limbless12246313limbless
limeless10249663limeless
limiest93716103li_miest
limitless1142943limitless
limpest113712313li_mpest
lineless82711943lineless
lingiest93715263lingiest
liniest73321153li_niest
lintels73311163lintels_
lipless9259553li_pless
lippiest122310613lippiest
lisles63416283li_sles_
listees73416673listees_
listels74212433listels_
liteness82213213liteness
litotes7311183litotes_
litres65220393li_tres_
litten64014873litt_e_n
litter64324853litt_e_r
litters73422573litt_ers
littery103710493litt_ery
littleness1045023littleness
liveliest1247093liveliest
livest95315733li__vest
loftiest1139083loftiest
loftless1135903loftless
lottes65322753lott_es_
loyalest11146723loyalest
lustiest82914493lustiest
mettles94115023mettles_
micklest16219123micklest
miltiest103015173miltiest
mintiest103217143mintiest
mistiest103018313mistiest
mitiest93520053mi_tiest
mottles93415803mottles_
nattiest83215353nattiest
nettiest83112433nettiest
nettles73214083nettles_
nettliest945413nettliest
niftiest112910073niftiest
nimblest1236923nimblest
nuttiest82312143nuttiest
pettiest103113963pettiest
pettles93916483pettles_
pintles94118723pintles_
pithiest132711443pithiest
pithless13117023pithless
pitiless10127333pitiless
plottiest11287833plottiest
pottiest102815973pottiest
pottles93816983pottles_
rattiest83516113rattiest
rattles73217303rattles_
riftless1136943riftless
ritziest17237843ritziest
ruttiest82712663ruttiest
settles73916003settles_
shittiest1238333shittiest
siltiest83515613siltiest
simplest122310223simplest
skittles1245763skittles_
slitless8268143sli_tless
sluttiest937333sluttiest
spittles1038333spittles_
stalest73720173_stalest
stillest8311073stillest
subtlest10511363subtlest
tattiest83415383tattiest
tattles73616283tattles_
tintless8239863tintless
titles63719923ti_tles_
titlist7312923ti_tlist
titties73617363titties_
tittle63613323tittle__
vilest9416843vi__lest
vitalist11313393vitalist
vittle94711753vittle__
vittled11347343vittle_d
wattest102412153watt_est
wattles103814073wattles_
wattless11268723wattless
wettest10239363wett_est
whittles1496673whittles_
wiftiest14279173wiftiest
wintles103414983wintles_
withiest142411243withiest
witless103310983wi_tless

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.420425454.8
2DLD Change Limit1461621716.34623032.1
3Display Results1711710.0602850.0
 (SQL Overall)1786911716.82626178.0
 
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.