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

109 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
dampening153546(None) 
damning114211632dam__ning
damping133414002damp__ing
darkening1535682darkening
davening13258872da_vening
deepening1335612deepening
hampering1738862hampering
happening1735592happening
pampering1638382pampering
tampering1438452tampering
tamponing1445992tamponing
aliening91510893_aliening
amending12308913_am_ending
amping114317573_amp__ing
appending1536283_appending
battening12268853battening
bumpering1636593bumpering
cambering16109873cambering
cameoing1379063cam_eoing
campesino1544633campesino
camping143118973camp__ing
campusing1654913campusing
capering132414963ca_pering
careening12310013careening
carpeting1439483carpeting
compering163414163compering
competing163712463competing
dackering1737383dackering
daggering13246113daggering
daikering1536103daikering
damaging1337383dam_aging
damascening1751483damascening
damasking1744603damasking
damming133812743dam__ming
dampen114310593dampe__n_
dampened1435623dampen_ed
dampener1335533dampen_er
dampeners1444663dampeners
dampens12348563dampe__ns
dampings14377523damp__ings
dandering122511063dandering
dangering12239303dangering
dapping133714793da_p_ping
dappling1436843da_ppling
darning93817333da__rning
dawning124111013da__wning
deadening1277583deadening
deafening1476273deafening
demeaning1337243demeaning
dementing13311043dem_enting
depending14208783d_epending
deponing121211213d_eponing
diapering1339033diapering
dimpling14199023dimp_ling
dispending1547923dispending
dispensing1448233dispensing
dizening19177143d_izening
dovening13238353d_ovening
dozening19236183d_ozening
dumping133712913dump__ing
dumpling14217893dump_ling
fastening13268603fastening
fattening13287833fattening
gammoning1545063gammoning
gardening1236513gardening
hamboning1745893hamboning
hammering1737633hammering
happenings1842623happenings
hardening1438023hardening
harkening1746923harkening
hastening13259483hastening
havening15258553ha_vening
impeding1436563_impeding
impending1535933_impending
imponing1338773_imponing
ladening1078823la_dening
lamenting1237693lam_enting
lamping123116003lamp__ing
lampooning1543533lampooning
lappering14258843lappering
latening9711493la_tening
lippening14234943lippening
maddening1445113maddening
mammering1337333mammering
omening10310093_om_ening
opening1039923__opening
papering132213313pa_pering
paupering1437273paupering
plumpening1742443plumpening
rampaging1544513rampaging
ramping123316873ramp__ing
rappeling1435963rappeling
rattening10288763rattening
ravening122611293ra_vening
reopening1248823reopening
ripening1138573_ripening
saddening1245213saddening
sampling13510643samp_ling
scampering1745323scampering
sharpening1644883sharpening
simpering1449293simpering
stampeding1642983stampeding
tamping122815813tamp__ing
tapering112112503ta_pering
tautening1035843tautening
tempering1438733tempering
vamping152810233vamp__ing
wakening1636323wa_kening
yammering1735193yammering

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411096.96621338.1
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.45223978.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.