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

206 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
skittles124576(None) 
kittles113012491_kittles
skittle1135531skittle_
spittles1038331spittles
brittles10178652brittles
cuittles1045902cuittles
kettles113411612_kettles
kirtles11309662_kirtles
kitties113213622_kitties
kittle104012172_kittle_
kittled12388192_kittled
kittler11338162_kittler
kittlest12297572_kittlest
littles73212782_littles
scuttles1056502scuttles
settles73916002s_ettles
shuttles1136552shuttles
skatoles1236142skatoles
skiffles18265712skiffles
skirtless13254422skirtless
skites104418042ski_t_es
skitter113810402skitt_er
skitters12349552skitters
spittle937922spittle_
tittles73413252_tittles
vittles103211112_vittles
whittles1496672whittles
battles94517683_battles
belittles1143873belittles
bottles94216273_bottles
brattles10199333brattles
bristles101510433bristles
brittle9168603brittle_
brittled11186093brittled
brittler10165983brittler
brittlest11146193brittlest
chitties13310773chitties
citoles9312553_citoles
cuittle946403cuittle_
cuittled1133993cuittled
cuttles93613923_cuttles
ditties83116983_ditties
dottles83912283_dottles
entitles8710663entitles
epistles1047783epistles
fettles103912733_fettles
gristles9189203gristles
guttles83011933_guttles
intitles8710003intitles
istles62814983__istles
ixtles13217063__ixtles
kettle104311613_kettle_
kibbles153510253_kibbles
kilties113014143_kilties
kindles123614843_kindles
kirtle10309473_kirtle_
kirtled12287033_kirtled
kites95432553_ki_t_es
kithes135016653_ki_thes
kitted115114833_kitt_ed
kittel10368873_kitt_el
kitten104611483_kitt_en
kittens11347583_kittens
little63312163_little_
littler7348553_littler
littlest8309243_littlest
mettles94115023_mettles
mottles93415803_mottles
nettles73214083_nettles
pettles93916483_pettles
pintles94118733_pintles
pottles93816983_pottles
prattles10189413prattles
rattles73217303_rattles
retitles83612593retitles
scotties1039753scotties
scuttle936463scuttle_
scuttled1134533scuttled
settees73513633s_ettees
settle63915663s_ettle_
settled83210873s_ettled
settler73410653s_ettler
settlers8289023s_ettlers
sextiles1537643sextiles
shiftless15265303shiftless
shingles123111113shingles
shirtless12266413shirtless
shitakes1546113shitakes
shitless11249243shi_tless
shittahs14114103shittahs
shitted114212053shitt_ed
shittier1137313shittier
shittiest1238343shittiest
shittims1344423shittims
shuttle1046103shuttle_
shuttled1234673shuttled
shuttler1164903shuttler
shuttlers1254123shuttlers
sickles133417543s_ickles
sidles74721153s_i_dles
similes92915233s_imiles
simples113014943s_imples
singles83520433s_ingles
sites56045433s_i_t_es
sitten64113823s_itt_en
sitter63323383s_itt_er
sitters74221553s_itters
situses72710493s_ituses
sixtes133612403s_ixt_es
sixties14310973s_ixties
sizzles15349633s_izzles
skates104219403sk_at_es
skatole1135693skatole_
skatols1135533skatol_s
sketches1746823sketches
skiable1338883skiable_
skies95026843ski___es
skiffle17225203skiffle_
skiffled19244423skiffled
skiffless19243053skiffless
skilled123110863ski_lled
skilless12246763ski_lless
skillet113512153ski_llet
skillets12226823ski_llets
skills104313923ski__lls
skinless12216973ski_nless
skirled12348183ski_rled
skirls10449823ski_rl_s
skirted12388613skirt_ed
skirter11338483skirt_er
skirters12337243skirters
skirts104111503skirt__s
skite95120063ski_t_e_
skited114313483ski_t_ed
skits94721873ski_t__s
skittered1434633skittered
skittery15315103skittery
skittish1544503skittish
skives134113943ski__ves
skivvies18112883skivvies
slitless8268143sli_tless
slitted83513313slitt_ed
slitter73615873slitt_er
slitters84014133slitters
slittier837003slittier
slittiest938213slittiest
smiles84522293smi__les
smites83921923smi_t_es
smithies1337913smithies
smitten936693smitt_en
sniffles14257723sniffles
sniggles10307313sniggles
snitches13148983snitches
spatzles1935303spatzles
spicules12219803spicules
spiles84227913spi__les
spindles112710353spindles
spinules10249333spinules
spitals93011593spital_s
spites84127333spi_t_es
spitted103912703spitt_ed
spitter94015183spitt_er
spitters104113383spitters
spitzes1849183spi_tzes
sprattles1174883sprattles
spurtles1037783spurtles
stales65538293s__tales
startles82111963startles
steles63725663s__teles
stickles142512103stickles
stifles103013393sti_fles
stiles64328773s__tiles
stipples1247023stipples
stipules1037053stipules
stitches131410593stitches
stithies1139233stithies
stoles63927673s__toles
styles94418653s__tyles
subtitles1156853subtitles
suites63727403sui_t_es
surtitles945633surtitles
suttees74114063s_uttees
swiftlet1444793swiftlet
swiftlets1542723swiftlets
swindles12319503swindles
swingles12319543swingles
swiples12339643swi_ples
swipples1534843swipples
switches16159133switches
swizzles1953783swizzles
systoles1146483systoles
tattles73616283_tattles
thistles1198233thistles
titles63719923_ti_tles
titties73617363_titties
tittle63613323_tittle_
twattles1154383twattles
vittle94711753_vittle_
vittled11347343_vittled
wattles103814073_wattles
whistles14108213whistles
whittle13106103whittle_
whittled1594913whittled
whittler1495193whittler
whittlers1594333whittlers
wintles103414983_wintles

Search took 9 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.423422437.4
2DLD Change Limit1461622067.78018786.9
3Display Results2062060.0802575.0
 (SQL Overall)1786912068.28321573.2
 
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.