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

232 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
tetanus73793(None) 
cetanes9315132cetanes
petasus946362petasus
tenants7311012tenants
tetanal738022tetanal
tetanic9810132tetanic
tetanics10127372tetanics
tetanies8513552tetanies
tetanise8610202tetanise
tetanuses984612tetanuses
tetany959842tetan_y
titanous846552titanous
titans63414912titan_s
anus47131113___anus
beanos85516513be_anos
beans75734693be_an_s
beaus75127113be_a_us
betaines10313293betaines
betakes134212523betakes
betas75528763beta__s
bethanks1765313bethanks
betons84919553beton_s
bezants1877343bezants
butanes9312743butanes
cetane8315283cetan_e
cotans81317923cotan_s
deans66131393de_an_s
decanes103118913decanes
decants103514443decants
dedans85915073dedan_s
defangs1235363defangs
demands114311413demands
desands94810163desands
details84214043details
detains83716093detains
detents83615153detents
detinue85010033detinue
detinues9569823detinues
dewans105215143dewan_s
elands74914773_elands
elans55527753_elan_s
etapes85415293_etapes
etas46432273_eta__s
ethanes103713513ethanes
ethnos947053_ethnos
etnas54713933_et_nas
fetas85624403feta__s
fetus85816543fet__us
gelants82611443gelants
genus65319833ge__nus
getas65421483geta__s
gitanos837173gitanos
heptanes1339003heptanes
hetmans12187593hetman_s
hexanes17319463hexanes
jeans126022113je_an_s
jetons134512613jeton_s
ketenes114813503ketenes
ketones115014503ketones
leans55536253le_an_s
lemans85316393leman_s
levants1037723levants
manus75924933__manus
means75831233me_an_s
meatus85112923me_atus
melanous1048603melanous
menus75822843me__nus
metages102714973metages
metals84520883meta_ls
metates92720013metates
methanes133812163methanes
mutants938583mutants
octanes91111393octanes
octans81411143octan_s
octants9128733octants
peans75437643pe_an_s
peanut8318183pe_anut
peanuts936993pe_anuts
pecans101515833pecan_s
pedants10310113pedants
pekans121710553pekan_s
penangs10268373penangs
pentanes10316083pentanes
petalous1058973petalous
petals84719813peta_ls
petards104311153petards
petasos948603petasos
petnaps1145033petnaps
petrous92714423petrous
ratans63819373ratan_s
recanes93222263recanes
recants93217093recants
redans75421023redan_s
rehangs1137563rehangs
relands85214883relands
remands104914883remands
remans84823003reman_s
retacks132210713retacks
retags73414303reta_gs
retails74718973retails
retains74522253retains
retakes113718863retakes
retapes93917423retapes
retards85015003retards
retaxes143615093retaxes
retenes76324623retenes
retinas74819353retinas
retines75134673retines
retints74717013retints
retinue75414843retinue
retinues85113153retinues
retunes76918403retunes
satangs8479713satangs
secants93413893secants
sedans74816093sedan_s
seitans73312303seitan_s
setons64620173seton_s
setous64917373set_ous
sewans95215903sewan_s
sextans14349263sextan_s
sextants15287383sextants
stands75118053_stands
stanes64933403_stanes
stangs75018163_stangs
stanks104917703_stanks
status65515213_status
tabus74820923__tabus
talus55423263__talus
tamandus1143943tamandus
tangs65028343__tangs
tanks94624733__tanks
tans46154823__tan_s
tantalus836373tantalus
tartanas8258893tartanas
tartans72615823tartan_s
tatamis939723tatamis
tatars64619793tata_rs
taus46342733__ta_us
taxus125512483__taxus
teacup1036253te_acup
teacups1133963te_acups
teaks94222903te_a_ks
teals56234133te_a_ls
teams75726513te_a_ms
tears55436463te_a_rs
teas45851493te_a__s
teases65426273te_ases
teats55636813te_a_ts
technos1236183technos
tedious838443tedious
teens56227483te_en_s
teinds738263te_inds
teledus835093teledus
tenaces92814513tenaces
tenails73713923tenails
tenancy1237503tenancy
tenant6322473tenan_t
tends65425583te__nds
tendus75111183te_ndus
tennis64015303te_nnis
tenons62916603tenon_s
tens45647413te__n_s
tentages91011043tentages
tents56434213te__nts
tenues63816443te__nues
tenuis64213083te__nuis
tenuous738483tenuous
teopans939203teopan_s
tepals85415043tepa_ls
tepas76521683tepa__s
terais64023513tera_is
terminus1037393terminus
ternes65422903te_rnes
terns55226873te_rn_s
terranes82514433terranes
tertians839103tertian_s
testates83615453testates
testons7313563teston_s
tetanised1096513tetanised
tetanises979873tetanises
tetanize17109953tetanize
tetanizes1889843tetanizes
tetanoid947203tetanoid
tethers103815313tethers
teths85418513tet__hs
tetotum9134613tetotum
tetotums10124063tetotums
tetrads82910193tetrads
tetras63017623tet_ras
tetris62816293tet_ris
tetryls1034643tetryls
tets45847463tet___s
tetters74320473tetters
texas126514933texa__s
texases1437573texases
thanes94918983t_hanes
thanks134313133t_hanks
thetas93011573theta__s
tisanes7311853tisanes
titan53318173titan__
titaness836723titaness
titania738293titania
titanias847103titanias
titanic968553titanic
titanism1048213titanism
titanium1046033titanium
titaniums1144763titaniums
titians72710453titian_s
titrants838483titrants
tolanes74216313tolanes
tolans64319273tolan_s
tomans85419133toman_s
tonus56324303__tonus
totals63115163tota_ls
tragus749233t_ragus
tranks104017763t_ranks
tranqs155210313t_ranqs
trans54933043t_ran_s
trepangs11205403trepangs
trepans92311593trepan_s
truants738163truants
tutus55214813tut__us
twangs10358093t_wangs
tyrants1037453tyrants
vegans103910853vegan_s
venus84918903ve__nus
weans85326743we_an_s
wetlands1244763wetlands
witans93412933witan_s
yeans86624883ye_an_s
zenanas16286233zenanas
zetas145018163zeta__s

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.233766914.2
2DLD Change Limit1340272326.97019229.1
3Display Results2322320.0932494.6
 (SQL Overall)1786912327.29624491.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.