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

180 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
tensity103910(None) 
density1137581density
tenuity1037451tenuity
densify1435292densify
enmity1137482_enmity
entity9312052_entity
extensity1944722extensity
intensity1247202intensity
lenity9612712len_ity
tenacity1347112tenacity
tensely1037362tensely
tensibly1345142tensibly
tensile72612732tensile
tensility1245802tensility
tensing84616652tensing
tension7311802tension
tensive10269912tensive
tenty86121602ten__ty
testy85419062te_s_ty
venosity1446022venosity
amenity1238333amen_ity
annuity1045543annuity
bedsit9312843bedsit_
bedsits1037563bedsits
cecity1398153ce_city
censing104215263censing
deity94316773de__ity
densely1146713densely
easily9313023_easily
endite73817593_endite
ensign737523_ensign
ensile62616473_ensile
ensky1235093_ens_ky
equity1838103_equity
eternity1146683eternity
falsity1335903falsity
feisty12449293feis_ty
felsite1039083felsite
ferity122813343fe_rity
henbit111412003henbit_
henbits12177003henbits
hessite1038993hessite
identity1245373identity
immensity1643503immensity
intensify1543993intensify
lanosity1146353lanosity
lenite6719983len_ite
lensing84015103lensing
levity1277903le_vity
menschy17354003menschy
mensing103915103mensing
messily12298813messily
obesity1275653obesity
otiosity1155763otiosity
penality13310713penality
penalty1267743penalty
penlite9313243penlite
pensil83013333pensi_l
pensile92713543pensile
pensils92811593pensils
pension9412203pension
pensive122610393pensive
pesty106421713pe_s_ty
piosity1268643piosity
reality10313573reality
resiny94617363re_siny
resit54241043re_sit_
resite64128453re_site
resits64725563re_sits
sanity9316203san_ity
senility1139683senility
seniti64317223sen_iti
sennit63117923sennit_
sennits73811283sennits
sensate7311893sensate
sensibly1345593sensibly
sensing84116953sensing
sensory10329093sensory
serosity1148783serosity
tanist6324593tanist_
tanistry1144543tanistry
tanists7313653tanists
tansies74521243tansies
tansy84514933tans__y
tantivy1335563tantivy
tasty84820313t_as_ty
tearily10311153tearily
teasing83918513teasing
techily1537123techily
tectite9310583tectite
teensier835573teensier
teensy9478273teens__y
tektite1136883tektite
temerity1346903temerity
tenably122210453tenably
tenail64516113tenai_l
tenails73713923tenails
tenancy1237503tenancy
tenant6322473tenant_
tenantry1144263tenantry
tenants7311013tenants
tending94419163tending
tenet55542213ten_et_
tenets65518953ten_ets
tenia55324483ten_i_a
teniae64517353ten_iae
tenias64720073ten_ias
tennies73017973tennies
tennis64015303tenni_s
tennist72813113tennist
tennists8297793tennists
tenorite8311993tenorite
tenpin8310583tenpi_n
tenpins9410073tenpins
tens45647413tens___
tense55225843tens__e
tensed74817833tens_ed
tenser64919433tens_er
tenses64722553tens_es
tensest72713313tensest
tensible1037243tensible
tensilely1244123tensilely
tensions8310223tensions
tensities9311333tensities
tensor63812673tens_or
tensors72712373tensors
tent46159863ten__t_
tenth85421833ten__th
tenthly1335743tenthly
tentie62521183tenti_e
tentier73815923tentier
tenting84621153tenting
tents56434213ten__ts
tenuis64213083tenui_s
tenuti638973ten_uti
tenuto648743ten_uto
teosinte845543teosinte
tepidity1445603tepidity
tergite8311003tergite
termite9313893termite
terrify1336353terrify
territ63421373territ_
territs72714503territs
tersely1038113tersely
test48651623te_s_t_
testa54822043te_s_ta
testify13246943testify
testily102910803testily
testis64916713te_stis
tests56530193te_s_ts
tinily94014433tin_ily
tinnily1047363tinnily
tinsmith1344073tinsmith
tipsily1236043tipsily
toasty9509563toas_ty
tonality1139793tonality
tonicity1348543tonicity
tonsil6311873tonsi_l
tonsils7310183tonsils
torosity1147243torosity
transit7317163transit_
transits8313503transits
trendily1256443trendily
trinity10310843trinity
trusty94710113trus_ty
twenty1236223twen__ty
twisty12426863twis_ty
unity84918493_un_ity
utensil7125213utensi_l
utensils8124963utensils
vanity12311933van_ity
varsity1356673varsity
venality1438683venality
verity123714853ve_rity
versify1636333versify
vinosity1445733vinosity
website1235323website
yeasty12438693yeas_ty
zenith1839073zen_ith
zesty176512163ze_s_ty

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.686260482.5
2DLD Change Limit1340271806.98619185.1
3Display Results1801800.0632857.1
 (SQL Overall)1786911807.73523101.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.