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

120 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
densify143529(None) 
density1137581density
dandify15245672dandify
deify124112762de__ify
denazify2442532denazify
densely1146712densely
identify1544132identify
tensity1039102tensity
versify1636332versify
aerify122810113ae_rify
basify1437513_basify
beatify1536593beatify
censing104215263censing
certify1546243certify
damnify1643453damnify
dandily12279633dandily
deasil71110983deasi_l
defy114921263de___fy
deity94316773de__ity
demulsify1852083demulsify
demystify2151403demystify
denary105316863den_ary
deni56929393den_i__
denial74720513den_ial
denied84318633den_ied
denier74420693den_ier
denies74729643den_ies
denim85518843den_i_m
denims95214323den_ims
denitrify1643073denitrify
denning93515173denning
dens55945073dens___
dense65923503dens__e
denser74115193dens_er
densest83112473densest
densified1446713densified
densifies1347993densifies
densifying1844813densifying
dentil74017883denti_l
dentils84115583dentils
dentin73919573denti_n
dentine83320243dentine
denting94422183denting
dentins83419223dentins
dentist8316743dentist
deny86027123den___y
denying123711293denying
depside1138403depside
descry1256183de_scry
design8408933de_sign
desire7415303de_sire
desist74818813de_sist
desoxy1744623de_soxy
destiny113111463destiny
detoxify2262173detoxify
dewily1338343de_wily
dignify1543893dignify
dingily1238103dingily
diversify1943453diversify
donsie7613643donsi_e
donsy96414683dons__y
dressily1246443dressily
dulcify1643023dulcify
easily9313023_easily
edify12308563_e_dify
enmity1137483_enmity
ensign737523_ensign
ensile62616473_ensile
ensky1235093_ens_ky
entity9312053_entity
falsify1643613falsify
fancify1834983fancify
gasify1336333_gasify
gentrify1544683gentrify
identity1245373identity
ignify1334513ign_ify
intensify1543993intensify
jellify2054543jellify
lenity9612713len_ity
lensing84015103lensing
menschy17354003menschy
mensing103915103mensing
messily12298813messily
metrify1535623metrify
minify1439253min_ify
ossify1244973_ossify
pensil83013333pensi_l
pensile92713543pensile
pensils92811593pensils
pension9412203pension
pensive122610393pensive
petrify1536573petrify
rectify1536453rectify
reedify1465763reedify
reify114814973re__ify
renotify1454833renotify
resift94017723re_sift
resiny94617363re_siny
reunify1344453reunify
russify1334063russify
salsify1334703salsify
sensibly1345593sensibly
sensing84116953sensing
sensory10329093sensory
tensely1037363tensely
tensibly1345143tensibly
tensile72612733tensile
tensing84616653tensing
tension7311803tension
tensive10269913tensive
tenuity1037453tenuity
terrify1336353terrify
testify13246943testify
unify113611113_un_ify
venosity1446023venosity
verbify1834993verbify
verify153110163ve_rify
vinify1536923vin_ify
zincify2443913zincify
zinkify2643123zinkify

Search took 7 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.390458182.1
2DLD Change Limit1340271205.84622926.3
3Display Results1201200.0462608.7
 (SQL Overall)1786911206.28228444.9
 
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.