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

106 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
dampener133553(None) 
dampened1435621dampened
dampeners1444661dampeners
damneder1243762damneder
damner95213432dam__ner
dampen114310592dampen__
dampens12348562dampen_s
damper114117752damp__er
dapperer1335762dapperer
darkener1335992darkener
deepener1145182deepener
hamperer15379092hamperer
pamperer14228332pamperer
tamperer12248892tamperer
aliener71011193_aliener
ambeer104511603_ambe_er
ameer75618983_am_e_er
amender10349613_am_ender
ammeter1148393_ammeter
ampere10514413_ampere_
amperes11313983_amperes
ampler104313303_amp_ler
barrener1038333barrener
battener10369393battener
camper124722213camp__er
camphene1746613camphene_
camphenes1846463camphenes
campier133313273camp_ier
caperer113013403ca_perer
careener1039323careener
carpenter1346493carpenter
compeer133811553compe_er
damager1157973dam_ager
dammer114317933dam__mer
damned104212913dam__ned
damners104112113dam__ners
damped124315583damp__ed
dampening1535463dampening
dampers123915693dampe_rs
dampest12411043dampe_st
damping133414003dampin_g
dampings14377523dampings
dampness1336073dampness
daphne12237013da_phne_
daphnes13327683da_phnes
dapper114016633da_p_per
darkened1435943darkened
darkeners1435153darkeners
darneder1033983darneder
darner74017303da__rner
davened124610073da_vened
deadener1036743deadener
deepened1235663deepened
deepeners1244523deepeners
dempster1355773dempster
diameter1148053diam_eter
dimeter10411893dim_eter
dimplier1336673dimplier
dispenser12128323dispenser
domineer1146273domineer
dumper114615213dump__er
dumpier12409653dump_ier
dumpster1344053dumpster
fastener11227833fastener
fattener11268113fattener
gammoner1345153gammoner
gardener1037103gardener
hammerer15278143hammerer
hamper134518653hamp__er
hampered16239933hampered
hamperers16287533hamperers
happened1635653happened
hardener1238883hardener
harkener1537573harkener
hastener11259133hastener
impeder12438533_impeder
lamenter1038863lam_enter
lampooner1343363lampooner
larcener1036493larcener
lateener835763lateener
opener83910993__opener
pamper124316663pamp__er
pampered15229233pampered
pamperers15236863pamperers
paperer113111903pa_perer
parcener1238473parcener
rampager1344453rampager
rattener8238533rattener
ravener104110733ra_vener
ripener937903_ripener
sampler113212013samp_ler
scamperer1544623scamperer
sharpener1444583sharpener
simperer1237173simperer
stampeder14304343stampeder
tamper104618513tamp__er
tampered13279463tampered
tamperers13227313tamperers
tamponed1336023tamponed
taperer92511793ta_perer
temperer12227723temperer
vamper134212653vamp__er
vampier14308233vamp_ier
wakener1446913wa_kener
warrener1136913warrener
yammerer15225483yammerer

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621067.62319173.8
3Display Results1061060.0462304.3
 (SQL Overall)1786911068.09222082.4
 
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.