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

206 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
lackering163937(None) 
dackering1737381dackering
lackeying1934921lackeying
bickering1837662bickering
blackening1944792blackening
cankering162110792cankering
cockering1839692cockering
daikering1536102daikering
dickering1737462dickering
flickering2044092flickering
hankering17239382hankering
jacketing2345642jacketing
laagering1136832laagering
lacewing1435842lac_ewing
lacking143821542lack__ing
lacquering2243602lacquering
laddering1237592laddering
lagering102212312la_gering
lappering14258842lappering
lathering13912252lathering
laveering1336812laveering
lawyering1655212lawyering
layering122310352la_yering
lechering1538442lechering
nickering1636572nickering
packeting1836852packeting
puckering1835882puckering
racketing1647872racketing
slackening1744342slackening
suckering1638102suckering
tuckering1635692tuckering
acceding1446093_acceding
adhering1338883_adhering
altering91917113_altering
angering102113803_angering
backfiring2243803backfiring
backing165523443back__ing
backswing2144903backswing
bacterin12410273bacterin_
bacterins13410643bacterins
badgering1436963badgering
bannering12208803bannering
bantering122414233bantering
barbering14229683barbering
bartering122313643bartering
battering122715143battering
blabbering14104363blabbering
blackenings2042563blackenings
blacking174213603black__ing
blanketing1743323blanketing
blathering16107583blathering
blattering13108713blattering
blinkering1744323blinkering
bracketing1945233bracketing
brokering1636283brokering
bucketing1835713bucketing
bucklering1944043bucklering
bunkering16207103bunkering
cacheting1737153cacheting
cackling172610943cack_ling
cambering16109873cambering
cantering122417373cantering
capering132414963ca_pering
careering12311203careering
casketing1635383casketing
catering112019903ca_tering
cering94522533__c_ering
checkering2244403checkering
clabbering17104583clabbering
clacking173313493clack__ing
clambering1776163clambering
clattering13109233clattering
clavering1538373cla_vering
clinkering1745233clinkering
daggering13246113daggering
dandering122511063dandering
dangering12239303dangering
darkening1535683darkening
docketing1785413docketing
faceting1438783fac_eting
factoring1537523factoring
faltering132211113faltering
fathering161010093fathering
flackeries1955423flackeries
flacking184311793flack__ing
flattering1498743flattering
gandering122111293gandering
garnering11298083garnering
gartering112111573gartering
gathering1499463gathering
glaceing1236533glac_e_ing
hachuring1845123hachuring
hacking173720613hack__ing
hackling183310163hack_ling
hackneying2342443hackneying
haltering132212003haltering
hammering1737633hammering
hampering1738863hampering
hankerings18244753hankerings
harkening1746923harkening
havering152211053ha_vering
hunkering17227123hunkering
jabbering2134443jabbering
jacking214515263jack__ing
jockeying2663293jockeying
kashering1736253kashering
labeling11311643la_beling
laboring112110143la_boring
labouring1236213labouring
lacerating1349443lac_erating
lacewings1543303lac_ewings
lacing94626233lac___ing
lacker125325623lacker___
lackered15108673lacker_ed
lackers134120543lacker__s
lacqueying2551793lacqueying
lactating1239183lactating
ladening1078823la_dening
lairing83715343la__iring
laking115027043la_k__ing
larking123718253lark__ing
latening9711493la_tening
laundering1245183laundering
laureling1035643laureling
lawyerings1752583lawyerings
layerings13235683la_yerings
leaguering1243813leaguering
leathering1488683leathering
lecturing1237303lecturing
leering83417643l__eering
lettering102112073lettering
levering122212503l_evering
lichening1545673lichening
lickerish1844423lickerish
licking144118283lick__ing
likening13246893l_ikening
limbering1488793limbering
lingering11310513lingering
lippering14217883lippering
littering102411983littering
livering122012383l_ivering
locking143718153lock__ing
loitering1039683loitering
loppering14237283loppering
lowering122210913l_owering
lucking143615833luck__ing
lumbering14117933lumbering
lustering102711203lustering
mackling172710063mack_ling
mammering1337333mammering
marketing1636513marketing
mastering122315303mastering
mattering122314053mattering
nattering102212213nattering
nickeling1645393nickeling
ochering14219393_ochering
packaging1945163packaging
packing164420723pack__ing
paltering122612893paltering
pampering1638383pampering
pandering133211963pandering
papering132213313pa_pering
pattering122314423pattering
paupering1437273paupering
pickeering1943533pickeering
picketing1835683picketing
plastering1339243plastering
pocketing1875853pocketing
racheting1537793racheting
racking144323663rack__ing
rocketing1666973rocketing
sabering112113743sa_bering
sacking144122703sack__ing
sacring103115983sac__ring
saggering12197793saggering
sickening1635993sickening
slabbering15104973slabbering
slacking153914133slack__ing
slandering1237243slandering
slathering14108283slathering
slavering1338723sla_vering
slickening1743903slickening
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 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 Filter1786911486410.423422437.4
2DLD Change Limit1486412067.50019818.8
3Display Results2062060.0932215.1
 (SQL Overall)1786912068.01622291.8
 
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.