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

165 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
dackering173738(None) 
daikering1536101daikering
dickering1737461dickering
lackering1639371lackering
bickering1837662bickering
cankering162110792cankering
cockering1839692cockering
daggering13246112daggering
dandering122511062dandering
dangering12239302dangering
darkening1535682darkening
docketing1785412docketing
hankering17239382hankering
jacketing2345642jacketing
lackeying1934922lackeying
nickering1636572nickering
packeting1836852packeting
puckering1835882puckering
racketing1647872racketing
suckering1638102suckering
tuckering1635692tuckering
acceding1446093_acceding
adhering1338883_adhering
altering91917113_altering
angering102113803_angering
backfiring2243803backfiring
backing165523443back__ing
backswing2144903backswing
bacterin12410273bacterin_
bacterins13410643bacterins
badgering1436963badgering
bannering12208803bannering
bantering122414233bantering
barbering14229683barbering
bartering122313643bartering
battering122715143battering
blackening1944793blackening
bracketing1945233bracketing
brokering1636283brokering
bucketing1835713bucketing
bucklering1944043bucklering
bunkering16207103bunkering
cacheting1737153cacheting
cackling172610943cack_ling
cambering16109873cambering
cantering122417373cantering
capering132414963ca_pering
careering12311203careering
casketing1635383casketing
catering112019903ca_tering
cering94522533__c_ering
checkering2244403checkering
dacker134920753dacker___
dackered16116893dacker_ed
dackers143417043dacker__s
dampening1535463dampening
daring84928683da___ring
darking134217343dark__ing
darkling1437483dark_ling
daundering1364463daundering
davening13258873da_vening
dayspring1642613dayspring
decerning1337293dec_erning
decking153915593deck__ing
declaring1339573declaring
decreeing1335523decreeing
dekeing13358353d_eke_ing
diapering1339033diapering
dicking153617613dick__ing
differing1746473differing
dithering1499853dithering
docking153615013dock__ing
doctoring1346183doctoring
doddering1335183doddering
dowering132510613d_owering
ducking154315053duck__ing
duckling16247703duck_ling
faceting1438783fac_eting
factoring1537523factoring
faltering132211113faltering
fathering161010093fathering
flickering2044093flickering
gandering122111293gandering
garnering11298083garnering
gartering112111573gartering
gathering1499463gathering
hachuring1845123hachuring
hacking173720613hack__ing
hackling183310163hack_ling
hackneying2342443hackneying
haltering132212003haltering
hammering1737633hammering
hampering1738863hampering
hankerings18244753hankerings
harkening1746923harkening
havering152211053ha_vering
hunkering17227123hunkering
jabbering2134443jabbering
jacking214515263jack__ing
jockeying2663293jockeying
kashering1736253kashering
laagering1136833laagering
lacewing1435843lac_ewing
lacking143821543lack__ing
lacquering2243603lacquering
laddering1237593laddering
lagering102212313la_gering
lappering14258843lappering
lathering13912253lathering
laveering1336813laveering
lawyering1655213lawyering
layering122310353la_yering
lechering1538443lechering
mackling172710063mack_ling
mammering1337333mammering
marketing1636513marketing
mastering122315303mastering
mattering122314053mattering
nattering102212213nattering
nickeling1645393nickeling
ochering14219393_ochering
packaging1945163packaging
packing164420723pack__ing
paltering122612893paltering
pampering1638383pampering
pandering133211963pandering
papering132213313pa_pering
pattering122314423pattering
paupering1437273paupering
pickeering1943533pickeering
picketing1835683picketing
pocketing1875853pocketing
racheting1537793racheting
racking144323663rack__ing
rocketing1666973rocketing
sabering112113743sa_bering
sacking144122703sack__ing
sacring103115983sac__ring
saggering12197793saggering
sickening1635993sickening
slackening1744343slackening
snickering1744863snickering
socketing1666383socketing
tabering112211423ta_bering
tacking144421483tack__ing
tackling153211123tack_ling
tampering1438453tampering
tapering112112503ta_pering
tattering102212323tattering
ticketing1635633ticketing
tinkering1437703tinkering
tochering1537153tochering
ulcering1139333ulc_ering
wafering15208893wa_fering
wagering13219523wa_gering
waitering13310713waitering
wakening1636323wa_kening
wandering143310983wandering
watering122316313wa_tering
wavering152410543wa_vering
whickering2343413whickering
yabbering1734023yabbering
yacking174315683yack__ing
yammering1735193yammering
yattering132410443yattering

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.423422437.4
2DLD Change Limit1486411657.48319863.8
3Display Results1651650.0762171.1
 (SQL Overall)1786911657.98222386.7
 
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.