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

211 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
tensions831022(None) 
pensions10311691pensions
tension7311801tension_
benisons1037042benisons
cessions1039852cessions
ensigns836352_ensigns
extensions1746132extensions
intensions1048402intensions
lesions73813872le_sions
mansions1069792mansions
mentions10312892mentions
pension9412202pension_
pensione1039772pensione
pensiones11410002pensiones
sessions839722sessions
telsons739222tels_ons
tendons8311472ten_dons
tenons62916602ten__ons
tenpins9410072tenpi_ns
tensing84616652tensi_ng
tensional946212tensional
tensioned1045612tensioned
tensioner945912tensioner
tensioners1044822tensioners
tensors72712372tens_ors
ternions838812ternions
testons7313562te_stons
torsions839182torsions
venisons1136132venisons
versions11310352versions
amnions93710913amn_ions
anions64123033_an_ions
ascensions1244613ascensions
attentions1045993attentions
aversions1247053aversions
basions94213953_basions
benison937123benison_
benthons1337973benthons
benzins1838693benzi_ns
benzoins1945573benzoins
bunions92210473bun_ions
censing104215263censi_ng
censors93611843cens_ors
cession939813cession_
consigns1137533consigns
decisions1248383decisions
delusions1037053delusions
dendrons1047393dendrons
dentins83419223denti_ns
derisions1038843derisions
designs9328313de_signs
detentions11148803detentions
dimensions1344613dimensions
distensions12146283distensions
elisions82210423elisions
elusions82610083elusions
emersions1147283emersions
enations83316903_enations
enjoins1457333_enjoins
ensign737523_ensign_
ensiles72714833_ensiles
envious1037223_envious
environs1144673_environs
envisions1245613_envisions
eosins64419163_eosi_ns
epsilons1044223_epsilons
erasions8310983erasions
erosions8310343erosions
essoins737603_essoins
etesians845473etesians
ethions1038483_ethions
evasions1136543evasions
eversions1238363eversions
extension1646293extension_
fanions103713073fan_ions
fenthions1544233fenthions
fenurons1174963fenurons
fermions1336203fermions
fissions1138033fissions
fusions1039153_fusions
gentians937563gentians
hellions11310023hellions
hessians1145053hessians
inions64417003_in_ions
intension948493intension_
intentions10411403intentions
kelsons1137323kels_ons
lections102413843lections
legions84611783le_gions
lenitions939473lenitions
lensing84015103lensi_ng
lesion64715063le_sion_
lessons73811023le_ssons
mansion9611543mansion_
menazons1945733menazons
mensing103915103mensi_ng
mention9314373mention_
mesons83215843me_s_ons
minions93314623min_ions
missions10311903missions
monsoons1047343monsoons
munnions1035273munnions
nasions73112383_nasions
nelsons738003nels_ons
neustons836833neustons
onions64016433_on_ions
passions10310583passions
pennons939713pen_nons
pensils92811593pensi_ls
pensioned1246653pensioned
pensioner1146663pensioner
pensioners1245363pensioners
pepsins11310433pepsi_ns
pereions10310853pereions
persons93717013pers_ons
pinions93413603pin_ions
plosions1038023plosions
pretensions1347083pretensions
pulsions1037713pulsions
reasons72514943reas_ons
recensions1248483recensions
recisions1139913recisions
regions83613473re_gions
renins64526453ren_i_ns
rennins74013413renni_ns
resigns83910963re_signs
resins64528773re_si_ns
retentions101611113retentions
reunions837273reunions
revisions1238593revisions
ronions73313343ron_ions
scansions1145323scansions
seasons72614233seas_ons
sections102714703sections
seisins73614393seisi_ns
seniors73413623sen_iors
sensations1059853sensations
sensing84116953sensi_ng
sensors73514643sens_ors
sensuous845903sensuous
session739763session_
sponsions1145223sponsions
stemsons1045003stems_ons
stepsons1045663steps_ons
sternsons944663sterns_ons
stetsons845623stets_ons
suasions838783suasions
tactions102912423tactions
talions7314113t_alions
tampions12358123tampions
tannins72813223tanni_ns
tansies74521243tansi_es
teashops1345733teashops
teasing83918513teasi_ng
teaspoons1143863teaspoons
tedious838443te_dious
teflons1036543te_flons
telson6310293tels_on_
tenacious1146423tenacious
tenails73713923tenai_ls
tending94419163tendi_ng
tendinous1044623tendinous
tendon7312033ten_don_
tenias64720073ten_i_as
tennies73017973tenni_es
tennis64015303tenni__s
tennises82810133tennises
tennists8297793tennists
tenon53320513ten__on_
tenors63217753ten__ors
tenpin8310583tenpi_n_
tenses64722553tens__es
tensible1037243tensible
tensibly1345143tensibly
tensile72612733tensi_le
tensioning1144983tensioning
tensionless1152673tensionless
tensities9311333tensities
tensity1039103tensi_ty
tensive10269913tensi_ve
tensor63812673tens_o_r
tenting84621153tenti_ng
tenuis64213083tenui__s
tenuous738483ten_uous
tenutos736623tenuto_s
ternion739493ternion_
tertians839103tertians
teston6313303te_ston_
testoons837323testoons
thermions1445333thermions
tinstone848173tinstone
tinstones948493tinstones
tocsins939963tocsi_ns
tompions12267003tompions
tonsils7310183tonsi_ls
torsion7310803torsion_
treasons848683treas_ons
trunnions943003trunnions
tuitions838283tuitions
turions7311573t_urions
unions64216753_un_ions
unisons748423_unisons
utensils8124963utensi_ls
venations12311723venations
venins93816703ven_i_ns
venison1036443venison_
version10310923version_
visions10311023_visions
wanions104011373wan_ions
weasons102310583weas_ons
xenons132710483xen__ons

Search took 10 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.453394461.4
2DLD Change Limit1461622118.86016496.8
3Display Results2112110.0932268.8
 (SQL Overall)1786912119.40618997.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.