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

208 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
scantest10171018(None) 
scantiest112611001scantiest
contest93523232_contest
saltest71916512s_altest
sanest64426692s_an_est
scaliest101714392scaliest
scandent1148492scandent
scanted104114392scante_d
scanter94215182scante_r
scanties103215422scanties_
scantness1135732scantness
scants85219722scant_s_
scarcest12169172scarcest
scariest101615942scariest
scattiest11268362scattiest
smartest10310182smartest
swankest15105932swankest
acutest94410603ac_utest
antes56334323__antes_
aptest82917513__aptest
attest62618613__attest
blandest113811043blandest
blankest14439063blankest
bluntest1036553bluntest
cagiest102916433_cagiest
cakiest133215663_cakiest
calmest11312343_calmest
candent10417363_candent
canes75350373_can_es_
canniest10313363_canniest
canoeist10310693_canoeist
canoes84725883_canoes_
canst74932213_can__st
canted94825783_cante_d
canteen9411083_canteen
canter85230113_cante_r
canters94827733_canters
cantles94721413_cantles_
cantos84826973_cantos_
cants77036943_cant_s_
cantus85117763_cantus_
cartes86239473_cartes_
castes85631863_castes_
cates75951893_ca_tes_
cattiest103016333_cattiest
chastest1349703chastest
coattest1038863coattest
congest104618773_congest
content94326153_content
contes84432913_contes_
contests103413383_contests
context163913433_context
crankest1438143crankest
curtest9713963_curtest
cutest85820143_c_utest
daftest11248943_daftest
dankest122611673_dankest
decentest1249083decentest
ecartes94212563ecartes_
exactest1745453exactest
faintest1139073faintest
fantast10311703_fantast
fastest102413723_fastest
fattest102913063_fattest
featest102715113fea_test
flattest1138713flattest
frankest1536963frankest
gauntest936603gauntest
giantess933893giantess
grandest10311573grandest
inanest72115363inan_est
iratest7312483ira_test
lankest112714113_lankest
latest63822703_la_test
leanest7415863lean_est
mantes84430783_mantes_
meanest9315703mean_est
neatest72516003nea_test
peartest10311303peartest
phantast1346923phantast
phattest1336913phattest
quaintest1845343quaintest
rankest112713813_rankest
recentest11410283recentest
saddest92412383s_addest
safest95016603s_a_fest
sagest74920263s_a_gest
sagiest82617983s_agiest
saltiest83117713s_altiest
sandiest93218683s_andiest
sanes55649073s_an_es_
sanies63031953s_anies_
santera7311303s_antera
santero7311133s_antero
santos64421833s_antos_
sates54949323s_a_tes_
sautes63924913s_autes_
sayest94217743s_a_yest
scabbiest1534913scabbiest
scabies11613333scabies_
scales84529313sca_les_
scanned104110893scanne_d
scanner94411813scanne_r
scanners10379703scanners
scans74625103scan__s_
scant79735073scan___t
scantier10309983scantier
scantily1337583scantily
scantiness1236883scantiness
scanting113914763scanting
scantly12419553scant_ly
scanty114014663scant__y
scapes105122263sca_pes_
scaredest1246633scaredest
scares85033003sca_res_
scarless10189053scarless
scarlet91516943scarle_t
scarlets10178573scarlets
scarriest11188393scarriest
scarted104816123scarte_d
scarts85321493scart_s_
scarves124511623scarves_
scathes124515713scathes_
scats75930603sca_t_s_
scatt76030093sca_t__t
scatted103512773scatte_d
scatter93815173scatte_r
scatters103612753scatters
scatts85914663sca_tts_
scenes84520353scen_es_
scented102811883scente_d
scentless1135113scentless
scents85317023scent_s_
scientist1147223scientist
sconces113811453sconces_
scones84521303scon_es_
scrawniest1543483scrawniest
scutes85219193sc_utes_
seamiest102715413seamiest
seances93015343seances_
searest73322023sea_rest
secants93413893secant_s_
secretest1147033secretest
sedatest9249393sedatest
senates73322583senates_
shadiest121711273shadiest
shakiest151910933shakiest
shaliest111415053shaliest
shantey134210043shante_y
shanteys14395513shanteys
shanties113116583shanties_
shantis103313103shantis_
sharpest1339143sharpest
shiniest113212493shiniest
shortest11310783shortest
silentest948103silentest
skankiest12145703skankiest
skates104219403ska_tes_
slackest14289393slackest
slangiest10129073slangiest
slanted83514743slante_d
slants64819083slant_s_
slates64934063sla_tes_
slatiest82616263slatiest
smallest1039403smallest
snakiest122110543snakiest
soapiest102412843soapiest
softest10310603s_oftest
soonest7415593soon_est
soundest9510973soundest
spaciest122310893spaciest
spanless10247363spanless
sparest94616423spa_rest
sparsest1048813sparsest
spates85028173spa_tes_
spiniest102813223spiniest
squattest1844613squattest
squintest1845703squintest
stablest103312943stablest
stactes91914633stactes_
stagiest91613403stagiest
staidest939803staidest
stalest73720173sta_lest
stances93715963stances_
stanchest14218213stanchest
stanes64933403stan_es_
starkest1239723starkest
states64337083sta_tes_
statist7317723sta_tist
stoniest8413543stoniest
stoutest837613stoutest
straitest949173straitest
strangest103210843strangest
suavest10310623sua_vest
subtest9513963s_ubtest
sunniest82712913sunniest
sveltest1135873sveltest
swankiest16136203swankiest
sweetest1137173sweetest
swiftest1434353swiftest
tannest72617853_tannest
tartest72517533_tartest
tautest72612443_tautest
vastest102911513_vastest
waniest103819113_waniest
wannest103915003_wannest
wattest102412153_wattest
zaniest163214773_zaniest

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.420425454.8
2DLD Change Limit1461622087.16020413.7
3Display Results2082080.0762736.8
 (SQL Overall)1786912087.65623340.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.