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

231 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
tetanies851355(None) 
tetanics10127371tetanics
tetanise8610201tetanise
tetanises979871tetanises
tetanizes1889841tetanizes
beanies93821092be_anies
betaines10313292betaines
betonies10413062betonies
botanies10312852botanies
cetanes9315132cetan_es
litanies8310992litanies
meanies93620742me_anies
ratanies8312922ratanies
tenancies1149172tenancies
tennies73017972te_nnies
testacies1148372testacies
tetanic9810132tetani_c
tetanised1096512tetanised
tetanize17109952tetanize
tetanized1988442tetanized
tetanus737932tetan_us
tetanuses984612tetanuses
titanias847102titanias
titanites997412titanites
apetalies1148003apetalies
astonies8815093astonies
ataxies142410013_ataxies
atonies75320953_atonies
beanie83618593be_anie_
beatniks1444043beatniks
beladies11310423beladies
bennies93917313be_nnies
betaine9413783betaine_
betakes134212523beta_kes
botanise1039643botanise
botanises1139163botanises
botanizes2048423botanizes
butanes9312743butan_es
cetane8315283cetan_e_
dataries9314033dataries
dearies83526273de_aries
decanes103118913decan_es
delaines9312963delaines
denies74729643de__nies
deranges1039973deranges
destinies10410843destinies
detaches1439653detaches
details84214043deta_ils
detained103111643detained
detainee92511723detainee
detainees10267153detainees
detainer92910793detainer
detainers10269103detainers
detains83716093deta_ins
detentes92712873detentes
detinues9569823detinues
dietaries10410663dietaries
dittanies1045733dittanies
easies64126633_e_asies
ebonies9312883_ebonies
etamines101611813_etamines
etamins91511833_etamins
etapes85415293_eta_pes
ethanes103713513ethan_es
ethnics1236263_ethnics
eutaxies1545793eutaxies
felonies11310993felonies
genies75324943ge__nies
heavies132713873he_avies
heinies102514543he_inies
heptanes1339003heptan_es
hexanes17319463hexan_es
iterances1148903iterances
jennies143511623je_nnies
jetties143613123jet_ties
ketamines15177033ketamines
ketenes114813503keten_es
ketones115014503keton_es
legacies1139043legacies
mealies92821933me_alies
meanie83718393me_anie_
meinies92516073me_inies
melanges1138613melanges
melanics1237733melanics
melanins10310383melanins
melanites11410723melanites
melanizes20410383melanizes
metages102714973meta_ges
metalise10416053metalise
metalises11315073metalises
metalizes20414243metalizes
metates92720013meta_tes
methanes133812163methan_es
mutinies10311503mutinies
neatniks1242763neatniks
nectaries1149813nectaries
neotenies948383neotenies
notaries8314933notaries
octanes91111393octan_es
peavies122213403pe_avies
penances12312443penances
pennies94218813pe_nnies
pentanes10316083pentan_es
peonies93620153pe_onies
petunias1066013petunias
readies83324713re_adies
recanes93222263recan_es
redenies9615713redenies
retables101712673retables
retails74718973reta_ils
retained93016093retained
retainer82913813retainer
retainers92510763retainers
retains74522253reta_ins
retakes113718863reta_kes
retallies939373retallies
retapes93917423reta_pes
retastes82212903retastes
retaxes143615093reta_xes
retenes76324623reten_es
reties65436193ret__ies
retines75134673retin_es
retinites9313503retinites
retinues85113153retinues
retries74129073ret_ries
retunes76918403retun_es
rhatanies1244983rhatanies
rotaries8315693rotaries
sanies63031953__sanies
seances93015343se_ances
sectaries11312243sectaries
setlines8312743setlines
stances93715963_stances
stanes64933403_stan_es
stanines85115673_stanines
steadies9311123ste_adies
tabanids1144963tabanids
tansies74521243__tansies
tatamis939723tatami_s
tatties74120343tat_ties
tawnies102812503t_awnies
taxies135817333__taxies
teaches122718353te_aches
tearier73815613te_arier
teariest82417263te_ariest
teases65426273te_a_ses
teatimes1039443teatimes
teazles16308923te_azles
techies12513603te_chies
technics1585463technics
tectonics1345953tectonics
teddies92711283te_ddies
teenier72611143te_enier
teeniest82112413te_eniest
tekkies1035943te_kkies
tellies73820503te_llies
tenaces92814513tena_ces
tenails73713923tena_ils
tenanted937043tenanted
tenantries1045673tenantries
tenants7311013tenan_ts
tendances1247573tendances
tenias64720073te__nias
tennis64015303te_nni_s
tennises82810133te_nnises
tenses64722553te__nses
tentacles1146713tentacles
tentages91011043tenta_ges
tentatives1345483tentatives
tenues63816443te__nues
tepefies1346893tepefies
terais64023513tera_i_s
ternaries9311643ternaries
ternes65422903te_rn_es
terranes82514433terran_es
terries73425633te_rries
terrines82117553terrines
tertiaries1047003tertiaries
testates83615453testa_tes
testifies12139263testifies
tetanal738023tetan_al
tetanical1146533tetanical
tetanoid947203tetanoid
tetany959843tetan__y
tetchier1336453tetchier
tetchiest1445793tetchiest
tetracids1245933tetracids
tetris62816293tet_ri_s
tetrodes939093tetrodes
teutonizes1946023teutonizes
texases1437573texa_ses
textuaries1743623textuaries
thanes94918983t_han_es
thebaines1454963thebaines
therapies1447723therapies
tiffanies1542693tiffanies
tisanes7311853tisan_es
titanates976093titanates
titaness836723titaness
titania738293titani_a
titanic968553titani_c
titanism1048213titanism
titanisms1147423titanisms
titanite898433titanite
titanium1046033titanium
titaniums1144763titaniums
titanous846553titanous
titans63414913titan__s
titties73617363tit_ties
toadies82914863t_oadies
tolanes74216313tolan_es
toonies73719883t_oonies
totalise8312503totalise
totalises9311783totalises
totalizes18311053totalizes
townies103113623t_ownies
trances93919643t_rances
trannies8415013trannies
treaties8316983treaties
truancies1146883truancies
tunnies73614263t_unnies
tutties73216473tut_ties
twankies1535893t_wankies
tweenies11146393tweenies
twoonies1155693twoonies
tympanies1644263tympanies
tyrannies1255533tyrannies
votaries11312013votaries
wearies103020223we_aries
weenies102915093we_enies
zanies153219673__zanies

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 Limit1461622317.65619091.2
3Display Results2312310.0932483.9
 (SQL Overall)1786912317.90522604.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.