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 “diversities” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
diversities155587(None) 
diversifies1853801diversifies
adversities1564352adversities
diversified1962952diversified
diversifier1862672diversifier
diversifiers1982032diversifiers
universities1553452universities
biodiversities2071283biodiversities
densities10310793d__ensities
diversions1446533diversi_ons
diversity1645213diversit__y
divinities1447733div_inities
hideosities1554203hideosities
inverities13410623inver_ities
perversities1754453perversities
riversides1444323riversi_des
severities1348513sever_ities
varsities1239243__varsities
verities111418043__ver_ities
versifies15159333__versifies
acerbities1444974_acerbities
adiposities1445104adi_posities
adversaries1553234adversaries
adversatives1952474adversatives
alterities10411044alter_ities
asperities1249764asper_ities
aversives1545914_aversi_ves
celerities1289774celer_ities
civilities1547844civ_ilities
coversines15128634coversi_nes
decertifies1744574decertifies
deformities1744284deformities
deities82621924d__e__ities
densifies1347994d__ensifies
desensitizes2254044desensitizes
desertifies1544704desertifies
detersives1444954detersi_ves
deverbatives2152174deverbatives
dexterities1945814dexter_ities
diacritics1563494diacr_itics
diapositives1852364diapositives
dichroites1645144dichroit_es
digestifs1484434dige_s_tifs
digestives1545214dige_stives
dignities1149594di__gnities
dimerizes2167944dimer_i_zes
dimities11314004di___mities
diorites9313524di_or_it_es
dirties83119384di__r__ties
disentitles1255264disentitles
disparities1446794disparities
disunities1177784di_sunities
divergences1874494divergences
divergencies1963574divergencies
diverges13258314diver___ges
diverse11429994divers___e_
diverseness1554774diverseness
diversify1943454divers__ify
diversifying2352164diversifying
diversion1346454divers__ion
diversionist1654514diversionist
diversionists1763254diversionists
diverted13199584diver__t_ed
diverter12238624diver__t_er
diverters13227874diver__ters
diverting142410334diver__ting
diverts114412034diver__t__s
divested13268214dive_s_t_ed
divesting14298484dive_s_ting
divestitures1662184divestitures
divests114510934dive_s_t__s
divestures14144254dive_stures
dolerites101410894doler_it_es
dubiosities1443614dubiosities
eternities1048064_eternities
extensities1885764extensities
ferities111416714__fer_ities
fidelities1445934fide_lities
generosities1353814generosities
gibbosities1652384gibbosities
hilarities1347154hilar_ities
idealities1148784_idealities
identities1146954_identities
immensities1554794immensities
inequities1946184_inequities
intensities11108914intensities
legerities1196884leger_ities
liberalities1446264liberalities
liberties1149204liber__ties
linealities1148224linealities
linearities1146804linearities
literalities1267544literalities
liveries11314374liver___ies
lividities1445584liv_idities
maternities1346014maternities
minorities1249464minor_ities
modernities1444634modernities
multiversities19151914multiversities
necessities1354574necessities
obesities1145844_obe_sities
overbites14310984_overbit_es
overdiversities2271694overdiversities
oversides131512664_oversi_des
oversizes211111614_oversi_zes
overstirs1238214_overs_tirs
paternities1345784paternities
pilosities1247804pi_losities
piosities11311724pi__osities
poverties1439514pover__ties
reverifies1645974rever_ifies
reversibles1682854reversibles
rimosities1246634ri_mosities
riverside1344914riversi_de_
serosities10410824__serosities
severalties1453664severalties
siderites10410434sider_it_es
silversides1552584silversi_des
sincerities1347094sincer_ities
sinuosities1145234sinuosities
sparsities1247324_sparsities
supercities15411564supercities
temerities1268484temer_ities
tensities9311334__tensities
tuberosities1472564tuberosities
universalities1763044universalities
venosities1347474__venosities
veracities1549504__veracities
verbifies17157134__verbifies
verbosities1644894__verbosities
verifies141313484__ver_ifies
verites103822264__ver_it_es
versicles1446354__versicles
versified16147594__versified
versifier15156534__versifier
versifiers16154144__versifiers
versines112213824__versi_nes
verstes104014284__vers_t_es
villosities1454184villosities
vinosities1346804vi_nosities
viscosities1645094viscosities
vivacities1844484viv_acities
viverrines1644134viverri_nes

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 Filter1786911488190.420425454.8
2DLD Change Limit1488191428.17318208.6
3Display Results1421420.0801775.0
 (SQL Overall)1786911428.67320603.1
 
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.