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

198 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
smallest103940(None) 
mallet84433052_malle_t
mallets93318492_mallets
sallet63734542s_alle_t
sallets73719652s_allets
saltest71916512s_altest
scaliest101714392scaliest
shaliest111415052shaliest
smaller93410332smalle_r
smallish1346572smallish
smallness1174512smallness
smalls84514122small_s_
smartest10310182smartest
smelliest1136602smelliest
snellest839492snellest
stablest103312942stablest
stalest73720172sta_lest
stillest8311072stillest
swellest1137662swellest
tallest7317092_tallest
ablest84721833__ablest
amplest11312333am_plest
baldest102313533_baldest
ballast9313993_ballast
ballet84733973_balle_t
ballets93719513_ballets
callet84536763_calle_t
callets93821703_callets
calmest11312343_calmest
chillest13259593chillest
coaliest10316223coaliest
coalless1038193coalless
dalles74222063_dalles_
diallist949553diallist
dismalest1246313disma_lest
drollest937353drollest
dullest8312633_dullest
evillest1146353evillest
falsest10310013_falsest
fellest10313753_fellest
frailest1139493frailest
fullest10313343_fullest
gallet73630853_galle_t
gallets83517403_gallets
goalless935723goalless
halest94823273_ha_lest
illest63615723__illest
macles107023223_macles_
maddest112311213_maddest
mailes84329113_mailes_
mailless10248583_mailless
males75049793_ma_les_
malled94626113_malle_d
mallee84525593_malle_e
mallees93315973_mallees
mallei84414633_malle_i
malleus92911313_malleus
malls76233433_mall_s_
malmiest123211023_malmiest
maltiest102916193_maltiest
manless93012933_manless
manliest102314943_manliest
maples104819423_maples_
marliest102415183_marliest
matiest92522453_matiest
matless93014043_matless
mayest114614793_ma_yest
maziest183613873_maziest
mealiest102215973mealiest
mealless10288363mealless
mildest102812063_mildest
milles84526563_milles_
millet84030743_mille_t
millets94216843_millets
molest85022743_m_olest
mullet84126823_mulle_t
mullets93614783_mullets
palest83926223_pa_lest
paliest93021603_paliest
pallet84232653_palle_t
pallets93919303_pallets
palliest102814633_palliest
phallist1338983phallist
realest73322433rea_lest
sables85026693s_ables_
saddest92412383s_addest
safest95016603s_a_fest
sagest74920263s_a_gest
sagiest82617983s_agiest
sailless82410373sailless
sales56055593s_a_les_
salient7419763s_alient
sallies73227813s_allies_
sallowest1246563s_allowest
saltiest83117713s_altiest
saltless8259343s_altless
salves94221763s_alves_
samlet84126563s_amle_t
samlets93813553s_amlets
samples112815453samples_
sanest64426693s_a_nest
sapless93313443s_apless
sayest94217743s_a_yest
scaleless1135513scaleless
scales84529313sca_les_
scalls84218203scall_s_
scantest101710183scantest
scarcest12169173scarcest
scariest101615943scariest
scarless10189053scarless
scarlet91516943scarle_t
scarlets10178573scarlets
seamiest102715413seamiest
seamless10238723seamless
searest73322023sea_rest
seatless83213003seatless
selles64426983s_elles_
shadiest121711273shadiest
shakiest151910933shakiest
shales94731253sha_les_
shallot103614133shall_ot
shallots11319503shallots
shallowest1643993shallowest
sharpest1339143sharpest
shelliest1238023shelliest
shoalest1168913shoalest
shoaliest1238503shoaliest
shrillest1245393shrillest
silliest84017103silliest
simplest122310223simplest
skilless12246763skilless
skillet113512153skille_t
skillets12226823skillets
slackest14289393slackest
slatiest82616263slatiest
sliest66621953s__liest
slyest93811363s__lyest
small74016263small___
smallage1145183smallage
smallages1245293smallages_
smallpox1941843smallpox
smalt74729333sma_l__t
smaltos9408193smaltos_
smalts85214893sma_lts_
smarmiest1335903smarmiest
smashes123914613smashes_
smazes174311663sma_zes_
smeariest1138113smeariest
smelled103511853smelle_d
smeller94212783smelle_r
smellers10329763smellers
smells83914743smell_s_
smileless1134693smileless
smiles84522293sm_iles_
smogless1134053smogless
smokiest1437883smokiest
smuggest1244373smuggest
snakiest122110543snakiest
snapless10287463snapless
snarliest91810203snarliest
soapiest102412843soapiest
soapless10278073soapless
soilless8279033soilless
soulless8218763soulless
spaciest122310893spaciest
spales84728103spa_les_
spalled103113133spalle_d
spaller92713473spalle_r
spallers102910733spallers
spalls84217343spall_s_
spanless10247363spanless
sparest94616423spa_rest
sparsest1048813sparsest
squalliest1944133squalliest
stables93219073stables_
stagiest91613403stagiest
staidest939803staidest
stales65538293sta_les_
stalkiest1347903stalkiest
stalkless1333723stalkless
stalled83515683stalle_d
stalls64019933stall_s_
staples93617213staples_
starkest1239723starkest
starless81610843starless
starlet71620123starle_t
starlets81610083starlets
stilliest939223stilliest
suavest10310623sua_vest
subtlest10511363subtlest
supplest1248943supplest
surliest82416913surliest
sveltest1135873sveltest
swales93920763swa_les_
swankest15105933swankest
vealiest112513203vealiest
wallet93327093_walle_t
wallets103914833_wallets

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.1561145455.1
2DLD Change Limit1461621986.76621602.4
3Display Results1981980.0762605.3
 (SQL Overall)1786911986.99825534.6
 
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.