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

139 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
daggering1324611(None) 
dangering12239301dangering
saggering12197791saggering
angering102113802_angering
badgering1436972badgering
buggering1435192buggering
dackering1737392dackering
daggling12237062dagg_ling
daikering1536102daikering
dandering122511062dandering
jiggering1934302jiggering
laagering1136832laagering
lagering102212312la_gering
saggaring12236242saggaring
staggering13194582staggering
swaggering16233622swaggering
wagering13219522wa_gering
adhering1338883_adhering
ageing84213403_a_ge_ing
agreeing10295903_agreeing
algerine9810283_algerine
altering91917123_altering
angeling102811733_angeling
auguring1036383_auguring
bagging123316983bagg__ing
bannering12208813bannering
bantering122414243bantering
barbering14229693barbering
bartering122313653bartering
battering122715153battering
beggaring1435183beggaring
cageling12310843ca_geling
cambering16109873cambering
cankering162110793cankering
cantering122417383cantering
capering132414963ca_pering
careering12311203careering
catering112019913ca_tering
dagger95017303dagger___
daggered12246403dagger_ed
daggerlike1751573daggerlike
daggers103714913dagger__s
dampening1535463dampening
danging103716093dang__ing
dangling112611233dang_ling
daring84928683da___ring
darkening1535683darkening
daundering1364463daundering
davening13258873da_vening
dayspring1642613dayspring
degerming1435753d_egerming
diapering1339033diapering
dickering1737463dickering
differing1746483differing
digging113513703digg__ing
dithering1499853dithering
doddering1335183doddering
dogearing1235763dogearing
doggeries1246673doggeries
dogging113312693dogg__ing
doggoning1343563doggoning
dowering132510613d_owering
dragging12308103dragg__ing
draggling1354613dragg_ling
endangering14133513endangering
fagging133714763fagg__ing
faggoting1543313faggoting
faltering132211123faltering
fathering161010093fathering
fingering1439193fingering
gagging93013533gagg__ing
gaggling10217463gagg_ling
gandering122111293gandering
garnering11298093garnering
gartering112111593gartering
gathering1499463gathering
gingering1238873gingering
hagging133114683hagg__ing
haggling14227273hagg_ling
haltering132212013haltering
hammering1737633hammering
hampering1738863hampering
hangaring1438033hangaring
hankering17239383hankering
havering152211053ha_vering
hungering14187683hungering
jabbering2134443jabbering
jaggeries18136973jaggeries
jagging173311993jagg__ing
kashering1736253kashering
lackering1639383lackering
laddering1237593laddering
lagging103316743lagg__ing
lappering14258843lappering
lathering13912253lathering
laveering1336813laveering
lawyering1655213lawyering
layering122310353la_yering
leaguering1243813leaguering
lingering11310513lingering
mammering1337333mammering
mastering122315313mastering
mattering122314063mattering
mongering13310353mongering
nagging102613043nagg__ing
nattering102212223nattering
paltering122612903paltering
pampering1638383pampering
pandering133211963pandering
papering132213313pa_pering
pargeting1338283pargeting
pattering122314433pattering
paupering1437273paupering
ragging103516683ragg__ing
rogering10310273_rogering
sabering112113743sa_bering
sagging103116103sagg__ing
sniggering1343763sniggering
tabering112211423ta_bering
tagging103014913tagg__ing
tampering1438453tampering
tangerine1048403tangerine
tapering112112503ta_pering
targeting1137303targeting
tattering102212333tattering
triggering1343883triggering
wafering15208893wa_fering
waggeries14127463waggeries
wagging133313353wagg__ing
waggling14197063wagg_ling
waggoning1543593waggoning
waitering13310723waitering
wandering143310983wandering
watering122316323wa_tering
wavering152410543wa_vering
yabbering1734023yabbering
yammering1735193yammering
yattering132410453yattering
zagging193210453zagg__ing

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.576310227.4
2DLD Change Limit1486411396.89321564.1
3Display Results1391390.0602316.7
 (SQL Overall)1786911397.52923733.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.