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

113 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
tensities931133(None) 
densities10310791densities
tenuities949761tenuities
densifies1347992densifies
enmities10611352_enmities
entities8617412_entities
extensities1885762extensities
intensities11108912intensities
lenities8315942len_ities
sensitise947292sensitise
sensitises1047642sensitises
sensitives1346132sensitives
sensitizes1946962sensitizes
tenacities1248582tenacities
tensilities1147652tensilities
venosities1347472venosities
amenities11310433amen_ities
annuities947463annuities
beasties102514653beas_ties
canities101519263can_ities
cecities12312043ce_cities
deities82621923de__ities
densified1446713densified
endites83717063_endit_es
ensiles72714833_ensi_les
enskies1138573_ens_kies
entitles8710663_entitles
equities17310773_equities
eternities1048063eternities
falsities1248133falsities
felsites1138073felsit_es
ferities111416713fe_rities
genitives1346663gen_itives
hessites1138613hessit_es
identities1146953identities
immensities1554793immensities
intensifies14105333intensifies
lanosities1047913lanosities
lenites7818443len_it_es
lenitives1247503len_itives
levities11310713le_vities
obesities1145843obesities
otiosities1046453otiosities
penalities121313463penalities
penalties11139503penalties
penlites10312273penlit_es
pensiones11410003pensiones
piosities11311723piosities
realities9316313realities
resites74027793re_sit_es
sanities81219773san_ities
senilities10312993senilities
sensates8511133sensat_es
sensibles1145953sensibles
sensitised1145043sensitised
sensitive1246963sensitive
sensitize1846563sensitize
sensitized2045833sensitized
sensitizer1944993sensitizer
sensitizers2053813sensitizers
serosities10410823serosities
tanistries1047063tanistries
tansies74521243tans__ies
tantivies1247103tantivies
tectites1039993tectit_es
tektites1236613tektit_es
temerities1268483temerities
tenailles946323tenailles
tenancies1149173tenancies
tenantries1045673tenantries
teniases838623ten_iases
tennies73017973ten__nies
tennises82810133tenni_ses
tenorites9311093tenorit_es
tenses64722553tens___es
tensible1037243tensible_
tensile72612733tensi_le_
tensility1245803tensility
tensioned1045613tensioned
tensioner945913tensioner
tensioners1044823tensioners
tensions8310223tensi_ons
tensity1039103tensit__y
tensive10269913tensi_ve_
tentatives1345483tentatives
tentie62521183ten__tie_
tentier73815923ten__tier
tentiest82115613ten__tiest
teosintes944553teosintes
tepidities1347713tepidities
tergites9310543tergit_es
termites10313693termit_es
terrifies12139723terrifies
testees74215913te_s_tees
testes65125823te_s_t_es
testier74015643te_s_tier
testiest82715223te_s_tiest
testifies12139263testifies
testis64916713te_s_ti_s
tonalities101711733tonalities
tonicities12410363tonicities
torosities1048263torosities
trinities9313343trinities
trusties82712853trus_ties
twenties1137503twen__ties
unities72520153_un_ities
vanities111414493van_ities
varsities1239243varsities
venalities131510723venalities
verities111418043ve_rities
versifies15159333versifies
vinosities1346803vinosities
websites1335183websit_es

Search took 9 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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411137.97018650.1
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.17221866.3
 
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.