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

143 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
kittlest1229757(None) 
kittles113012491kittles_
littlest8309241littlest
bittiest103012042bittiest
brittlest11146192brittlest
fittest102510802fitt_est
kettles113411612kettles_
kirtles11309662kirtles_
kitties113213622kitties_
kittle104012172kittle__
kittled12388192kittle_d
kittler11338162kittle_r
littles73212782littles_
nittiest82712602nittiest
skittles1245762skittles_
tittles73413252tittles_
vittles103211112vittles_
wittiest112711522wittiest
attest62618613_att_est
battiest104115553battiest
battles94517683battles_
bitsiest102610063bitsiest
bitterest1147713bitterest
bottles94216273bottles_
brittles10178653brittles_
cattiest103016333cattiest
citoles9312553citoles_
cuittles1045903cuittles_
cuttles93613923cuttles_
dictiest113212783dictiest
dirtiest93014203dirtiest
ditsiest92111323ditsiest
ditties83116983ditties_
ditziest18218473ditziest
dottiest92611393dottiest
dottles83912283dottles_
fattest102913063fatt_est
fattiest113514313fattiest
fettles103912733fettles_
ficklest17267903ficklest
gentlest93410573gentlest
giftless1245173giftless
grittiest10176983grittiest
guttiest92311223guttiest
guttles83011933guttles_
hiltless11297123hiltless
hitless103211193hi_tless
hottest10411383hott_est
idlest74014863_i_dlest
illest63615723_i_llest
istles62814983_istles_
ixtles13217063_ixtles_
jettiest15359593jettiest
kettle104311613kettle__
kibbles153510253kibbles_
kickiest13319673kickiest
kilties113014143kilties_
kindest12311503ki_ndest
kindles123614843kindles_
kindless13289243kindless
kindliest1436113kindliest
kingless13288693kingless
kinglet123114043kingle_t
kinglets13318583kinglets
kingliest1436523kingliest
kinkiest113110503kinkiest
kinless113310273ki_nless
kirtle10309473kirtle__
kirtled12287033kirtle_d
kites95432543ki_t_es_
kithes135016653ki_thes_
kitted115114833kitt_e_d
kittel10368873kitt_e_l
kitten104611483kitt_e_n
kittens11347583kitt_ens
kittling1336063kittling
knotless1264563knotless
knottiest13174563knottiest
lintiest82715913lintiest
lintless82710013lintless
listless8269263listless
lithest10513913li_thest
little63312163little__
littler7348553little_r
littlish1145043littlish
mettles94115023mettles_
micklest16219123micklest
miltiest103015173miltiest
mintiest103217143mintiest
mistiest103018313mistiest
mitiest93520053mi_tiest
mottles93415803mottles_
nattiest83215353nattiest
nettiest83112433nettiest
nettles73214083nettles_
nettliest945413nettliest
niftiest112910073niftiest
nimblest1236923nimblest
nuttiest82312143nuttiest
pettiest103113963pettiest
pettles93916483pettles_
pintles94118723pintles_
pithiest132711443pithiest
pithless13117023pithless
pitiless10127333pitiless
pottiest102815973pottiest
pottles93816983pottles_
rattiest83516113rattiest
rattles73217303rattles_
riftless1136943riftless
ritziest17237843ritziest
ruttiest82712663ruttiest
settles73916003settles_
shittiest1238333shittiest
siltiest83515613siltiest
simplest122310223simplest
skirtless13254423skirtless
skittle1135533skittle__
slittiest938203slittiest
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.1701051123.5
2DLD Change Limit1461621436.54622328.4
3Display Results1431430.0632269.8
 (SQL Overall)1786911436.77926359.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.