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

168 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
density113759(None) 
densify1435291densify
tensity1039101tensity
deity94316772de__ity
densely1146712densely
enmity1137482_enmity
entity9312052_entity
identity1245372identity
lenity9612712len_ity
tenuity1037452tenuity
venosity1446022venosity
adversity1643813adversity
amenity1238333amen_ity
annuity1045543annuity
bedsit9312843bedsit_
bedsits1037563bedsits
cecity1398153ce_city
censing104215263censing
dacoity1366183dacoity
dakoity1543423dakoity
dandify15245673dandify
dandily12279633dandily
deasil71110983deasi_l
debility1448643debility
debit85727853de_bit_
debits94214503de_bits
deceit93018213deceit_
deceits102810883deceits
deify124112763de__ify
deist64633593deis_t_
deistic10311173deistic
deists74916433deis_ts
delist74625053delist_
delists84414173delists
demit84832303de_mit_
demits94918073de_mits
denary105316863den_ary
denazify2442533denazify
dendrite1048783dendrite
deni56929393den_i__
denial74720513den_ial
denied84318633den_ied
denier74420693den_ier
denies74729643den_ies
denim85518843den_i_m
denims95214323den_ims
denning93515173denning
denote74118043den_ote
dens55945073dens___
dense65923503dens__e
denser74115193dens_er
densest83112473densest
densities10310793densities
dent57158413den__t_
dentality1348473dentality
dentate8315153dentate
dentil74017883denti_l
dentils84115583dentils
dentin73919573denti_n
dentine83320243dentine
denting94422183denting
dentins83419223dentins
dentist8316743dentist
dentistry1342493dentistry
dentists939263dentists
dents65031803den__ts
deny86027123den___y
denying123711293denying
deposit10313003deposit_
deposits1138843deposits
depside1138413depside
deputy12426713de_puty
descry1256183de_scry
design8408933de_sign
desire7415303de_sire
desist74818813de_sist
desists83611723de_sists
desoxy1744623de_soxy
despite10410123despite
destiny113111463destiny
dewily1338343de_wily
dignity1236463dignity
dimity12310483d_imity
dingily1238103dingily
diversity1645223diversity
donsie7613643donsi_e
donsy96414683dons__y
dressily1246443dressily
duality1147973duality
dunite7315013dun_ite
dunnite857333dunnite
dusty96018333d_us_ty
dynasty1463203dynasty
easily9313023_easily
edacity1336373edacity
endite73817593_endite
ensign737523_ensign
ensile62616473_ensile
ensky1235093_ens_ky
equity1838103_equity
extensity1944723extensity
falsity1335913falsity
feisty12449293feis_ty
felsite1039083felsite
ferity122813343fe_rity
henbit111412003henbit_
henbits12177003henbits
hessite1038993hessite
hideosity1643323hideosity
ideality1247153ideality
identify1544133identify
idoneity1243013idoneity
immensity1643503immensity
intensity1247203intensity
lanosity1146353lanosity
lenite6719983len_ite
lensing84015103lensing
levity1277903le_vity
menschy17354013menschy
mensing103915103mensing
messily12298813messily
obesity1275653obesity
penality13310713penality
penalty1267743penalty
penlite9313243penlite
pensil83013333pensi_l
pensile92713543pensile
pensils92811593pensils
pension9412203pension
pensive122610393pensive
pesty106421713pe_s_ty
piosity1268653piosity
reality10313573reality
resiny94617363re_siny
resit54241043re_sit_
resite64128453re_site
resits64725563re_sits
sanity9316203san_ity
senility1139683senility
seniti64317223sen_iti
sennit63117923sennit_
sennits73811283sennits
sensate7311893sensate
sensibly1345593sensibly
sensing84116953sensing
sensory10329093sensory
serosity1148793serosity
tenacity1347113tenacity
tensely1037363tensely
tensibly1345143tensibly
tensile72612733tensile
tensility1245813tensility
tensing84616653tensing
tension7311803tension
tensive10269913tensive
tenty86121603ten__ty
testy85419063te_s_ty
unity84918493_un_ity
vanity12311933van_ity
varsity1356673varsity
venality1438683venality
verity123714853ve_rity
versify1636333versify
vinosity1445743vinosity
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.423422437.4
2DLD Change Limit1340271686.82619634.8
3Display Results1681680.0632666.7
 (SQL Overall)1786911687.31224438.0
 
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.