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

140 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
benthon123769(None) 
benthons1337971benthons
benthos1238371benthos
benison937122benison
benthal1247962benthal
benthic1437472benthic
benthonic1644592benthonic
bento75922952bent_o_
bentos86218312bent_os
bethorn1238642be_thorn
beton76022062be_t_on
fenthion1444612fenthion
menthol1236732menthol
mention9314372mention
anethol1045383anethol
bastion9312473bastion
bathos116215633b_athos
baton75822423b_at_on
beacon10511373be_acon
beaten84617063beat_en
beckon14309383be_ckon
beechen14367703beechen
bellhop1445053bellhop
belon73924113be__lon
bench125619503bench__
benched154713943benched
bencher144113483bencher
benches143918603benches
benching163411343benching
benchtop1742173benchtop
benign938313ben_ign
benisons1037043benisons
bent67759913bent___
benthoses1446693benthoses
bents76033693bent__s
bentwood1444453bentwood
benzin1738933ben_zin
benzoin1846263benzoin
benzol1756993ben_zol
berth104917883berth__
bertha11429173berth_a
berthas12398763berthas
berthed13259123berthed
berthing14209603berthing
berths114712423berth_s
bestow1149463best_ow
bestrow1237253bestrow
bestrown1345203bestrown
betatron1045233betatron
beth96629233be_th__
bethank1666273be_thank
bethel1169643be_thel
bethink1677203be_think
bethorns1337323be_thorns
beths105519223be_th_s
betons84919553be_t_ons
betony114211583be_t_ony
betook12439603be_took
bettor83612223be_ttor
bevatron1343893bevatron
biathlon13153013biathlon
biotron937293biotron
bonbon10310073bon_bon
boston8513043bost_on
bouton8311533bout_on
boxthorn2043693boxthorn
bunion83111313bun_ion
burthen1236363burthen
burton8311273burt_on
button8310273b_utton
canton85722993cant_on
cento76625173cent_o_
centos85920463cent_os
dendron947653dendron
dentin73919573dent_in
enation73419233_enation
enteron7313343_enteron
enthrone111110113_enthrone
ethion938813_e_thion
ethos85514193_e_thos
fenthions1544233fenthions
fenuron1075153fenuron
festoon1037673festoon
gentian8310103gentian
gentoo7311313gent_oo
gentoos838633gentoos
heathen133410893heathen
intron64215023_intron
jeton124815403je_t_on
jetton1338033je_tton
kenotron1244463kenotron
lanthorn1147193lanthorn
lection92614863lection
lengthen1243533lengthen
lenition8310083lenition
lenten6312883lent_en
lento57223393lent_o_
lentos65317403lent_os
lepton82510803lept_on
melton8311553melt_on
menazon1846053menazon
menshen1236813menshen
menthene1347033menthene
menthols1347043menthols
mentions10312893mentions
mentor8414363ment_or
method1239033me_thod
nekton1036583nekt_on
neutron737763neutron
newton936983newt_on
obento837893obent_o_
obentos936713obent_os
pantheon1346323pantheon
pennon8310643pen_non
pension9412203pension
pentagon1146323pentagon
ponton83217643pont_on
pontoon93010703pontoon
python1447143_python
section92515663section
senhor93010813sen_hor
seton55223543se_t_on
sexton133610793sext_on
telethon1146003telethon
tendon7312033ten_don
tenon53320513ten__on
tension7311803tension
tenth85421833tenth__
tenthly1335743tenthly
tenths94412663tenth_s
teston6313303test_on
testoon748373testoon
venation11513503venation
venison1036453venison
wanton94413813want_on
wonton93410963wont_on
xanthan1736013xanthan
xanthin1747043xanthin
xanthone1847113xanthone
xenon122612453xen__on

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.406440125.6
2DLD Change Limit1340271407.14018771.3
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.59223536.7
 
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.