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

311 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
daftest1124894(None) 
deftest112611711deftest
aptest82917512_aptest
attest62618612_attest
daffiest1537842daffiest
dafter104813342dafte_r
daftness1235532daftness
dampest12411042dampest
dankest122611672dankest
darkest122512622darkest
dates65639152da_tes_
deafest112911512deaf_est
deffest14308802deffest
detest74122842d_etest
draftiest1335942draftiest
fastest102413722fastest
fattest102913062fattest
latest63822702la_test
leftest10269462leftest
oftest91212002_oftest
safest95016602saf_est
saltest71916512saltest
softest10310602softest
tartest72517532tartest
tautest72612442tautest
vastest102911512vastest
wattest102412152wattest
ablest84721833_ablest
acutest94410603acutest
addrest958633addrest
adeptest1145453adeptest
affect1448903_affect
afreet9315153_afreet
afresh1255503_afresh
after85719793_afte_r
afters94717073_afters
aftmost1244973_aftmost
aftosa996573_aftosa
airest63825263_airest
antes56334323_antes_
arrest63722633_arrest
artiest73121993_artiest
artist64125543_artist
ates45047923_a_tes_
attent62818323_attent
attests7278813_attests
autist64324943_autist
babiest114414753babiest
baddest112611143baddest
baldest102313533baldest
baptist11311873baptist
barest85327693ba_rest
basest84720493ba_sest
bastes85330383bastes_
bates75846343ba_tes_
battiest104115553battiest
buffest15298643buffest
cafes106426923caf_es_
cagiest102916433cagiest
cakiest133215663cakiest
calmest11312343calmest
cartes86239473cartes_
castes85631863castes_
cates75951893ca_tes_
cattiest103016333cattiest
chastest1349703chastest
coattest1038863coattest
contest93523233contest
craftiest1436913craftiest
curtest9713963curtest
cutest85820143_cutest
daces85030683da_ces_
dacites101114593dacites_
dadaist9310103dadaist
dadoes85616533dadoes_
daffed14429493daffe_d
daffs125116423daf_fs_
daft85537253daf___t
daftly1335443daft_ly
dagoes85714603dagoes_
daintiest1039153daintiest
daises74318983daises_
dales66439743da_les_
dalles74222063dalles_
dames85435853da_mes_
damndest1276003damndest
dances95120653dances_
dandiest103415033dandiest
dares66146703da_res_
darndest1067223darndest
darted84620923darte_d
darter75320363darte_r
darters84017603darters
dartles84014133dartles_
darts67635733dart_s_
dashes106124983dashes_
dashiest12311113dashiest
date56443323da_te__
dated75530993da_te_d
dater65332313da_te_r
daters74827373da_ters
datos65222783da_tos_
dattos74311903dattos_
daubes94913703daubes_
daubiest1138233daubiest
dauted84114933daute_d
dauties83315763dauties_
dauts67822243daut_s_
davies105020513davies_
dawted11489683dawte_d
dawties113312703dawties_
dawts97216123dawt_s_
dazes155024143da_zes_
deadest93014883deadest
deafness1236213deafness
dearest83618673dearest
deepest10310443deepest
defeat103817163def_eat
defect124816173def_ect
defies104624053defies_
deflect13399973deflect
deforest1238793deforest
defrost1139553defrost
defter104215923defte_r
deftness1236303deftness
densest83112473densest
dentist8316743dentist
detect94217403d_etect
detent73624483d_etent
detests83711743d_etests
devest104418703d_evest
dewiest11312343dewiest
diciest103316523diciest
dictiest113212783dictiest
digest84019623d_igest
dimmest1249253dimmest
direst75024243d_irest
dirtiest93014203dirtiest
distent84120853distent
dites66339153d_ites_
divest106820073d_ivest
doest65829523d__oest
dopiest103315993dopiest
dotes65836693d_otes_
dotiest83717453dotiest
dottiest92611393dottiest
dourest8312943dourest
doziest174012473doziest
drabbest13295663drabbest
draffiest1644363draffiest
drafted12439033drafte_d
draftee11379523drafte_e
draftees12225253draftees
drafter11449423drafte_r
drafters12338523drafters
drafts105012533draft_s_
drest65530343d__rest
driest74722753d_riest
driftiest1335943driftiest
dryest104811123d_ryest
dullest8312633dullest
dumbest1238743dumbest
dunnest83312263dunnest
dustiest93015073dustiest
dwarfest1543473dwarfest
earnest7318733earnest
easiest72318773easiest
exactest1745453exactest
fabbest1438033fabbest
fainest10417703fainest
faintest1139073faintest
fairest10412293fairest
falsest10310013falsest
fantast10311703fantast
farthest1499863farthest
fates85139233fa_tes_
fattiest113514313fattiest
featest102715113featest
fest74949443__f_est
fittest102510803fittest
flattest1138713flattest
gabfest1336453gabfest
gaffes134811103gaffes_
gamest94919923ga_mest
gamiest102816223gamiest
gashest114813413gashest
gates65939513ga_tes_
gauntest936603gauntest
gayest104314333ga_yest
haddest122711993haddest
haffet15311703haffe_t
haffets1636053haffets
hafted134713833hafte_d
hafter124815883hafte_r
hafters134614333hafters
hafts116219463haft_s_
halest94823273ha_lest
hardest113118413hardest
harvest132112753harvest
hastes95727073hastes_
hastiest112916493hastiest
hates86742573ha_tes_
haziest193313003haziest
heftiest1439183heftiest
hottest10411383hottest
iffiest1337963iffiest
infest93315433inf_est
iratest7312483iratest
justest1449893justest
laciest93819033laciest
lakiest113517263lakiest
lamest84722763la_mest
lankest112714113lankest
largest83715103largest
latent64124303la_tent
latests73910313la_tests
lattes65324203lattes_
laxest134913363la_xest
laziest163814473laziest
leafiest113410883leafiest
leftist10279353leftist
loftiest1139083loftiest
maddest112311213maddest
maltiest102916193maltiest
mantes84430783mantes_
mates75251363ma_tes_
matiest92522453matiest
mattes85624533mattes_
mayest114614793ma_yest
maziest183613873maziest
mostest9314793mostest
mutest84218053_mutest
naivest10309473naivest
nastiest83615953nastiest
nates55238333na_tes_
nattiest83215353nattiest
neatest72516003neatest
niftiest112910073niftiest
oakiest112913923oakiest
obtest81213013_obtest
paciest112917803paciest
palest83926223pa_lest
paliest93021603paliest
pastes85233913pastes_
pastiest103319543pastiest
patent84524923pa_tent
pates76047893pa_tes_
peartest10311303peartest
pertest9317043pertest
phattest1336913phattest
pretest9517633pretest
protest9317533protest
raciest92820013raciest
rafted104714703rafte_d
rafter94517583rafte_r
rafters103715633rafters
rafts87820633raft_s_
rankest112713813rankest
rarest65725483ra_rest
rashest103916873rashest
rates55352013ra_tes_
rattiest83516113rattiest
rawest93615063ra_west
retest64028453_retest
rifest93114583rif_est
saddest92412383saddest
safes85226723saf_es_
sagest74920263sa_gest
sagiest82617983sagiest
saltiest83117713saltiest
sanest64426693sa_nest
sates54949323sa_tes_
sautes63924913sautes_
sayest94217743sa_yest
scantest101710183scantest
sedatest9249393seda_test
smartest10310183smartest
subtest9513963subtest
swiftest1434353swiftest
tallest7317093tallest
tamest85721293ta_mest
tannest72617853tannest
tartiest82718313tartiest
tastes64126423tastes_
tastiest83216633tastiest
tates55444983ta_tes_
tattiest83415383tattiest
test48651623___test
tritest7315273tritest
tuftiest1138283tuftiest
vaguest1137333vaguest
vainest10315763vainest
vastiest112713073vastiest
wackest164710863wackest
wafted134012143wafte_d
wafter124114613wafte_r
wafters134112813wafters
wafts116920553waft_s_
waniest103819113waniest
wannest103915003wannest
wariest105122503wariest
warmest123113033warmest
wartiest113614643wartiest
wastes96224883wastes_
waviest134513073waviest
waxiest173510883waxiest
wettest10239363wettest
whitest133710113whitest
wiftiest14279173wiftiest
yarest95018913ya_rest
zaniest163214773zaniest

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 Filter1786911340270.403443402.0
2DLD Change Limit1340273116.76619808.9
3Display Results3113110.1102827.3
 (SQL Overall)1786913117.27924548.8
 
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.