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

281 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
plotzing2027615(None) 
plotting113011011plotting
blitzing2035902blitzing
blotting113910432blotting
clothing14278782clothing
clotting113110642clotting
glitzing1934972glitzing
glozing18338892glo_zing
lotting82917752_lotting
photoing1439072photoing
piloting1139692pilot_ing
plating103823072plat_ing
platting114813032platting
plodding13166342plodding
plonking15358562plonking
plopping12318702plopping
plotline1037642plotline
plowing133111722plo_wing
ploying132811572plo_ying
potting103720892p_otting
putzing19359122p_utzing
slotting92612612slotting
allotting1046503allotting
azotizing1846013azotizing
blatting114111653blatting
blazing193612393bl_azing
bloating113512813bloating
blobbing12246923blobbing
blocking174510573blocking
blogging13369013blogging
blooding122410653blooding
blooming13299433blooming
blooping13248843blooping
blotching1734963blotching
blousing1138793blousing
blowing133813053blo_wing
bolting104416763bolt_ing
booting103821363boot_ing
boozing194012163_boozing
bronzing2037693bronzing
cloaking15299713cloaking
clocking174312413clocking
clogging13368503clogging
clomping15329653clomping
cloning103215473clo_ning
clonking153810153clonking
clopping153511083clopping
closing103114843clo_sing
clothings15264433clothings
cloturing1245473cloturing
clouding12269493clouding
clouring112811273clouring
clouting113011683clouting
clowning14307253clowning
cloying133511753clo_ying
coplotting1555953coplotting
coting94629253_cot_ing
doting84821913_dot_ing
dotting93314483_dotting
dozing174214193_do_zing
elating83423083elat_ing
eloining9310443eloining
eloping103512833elo_ping
eluting84115293elut_ing
emoting10313563emot_ing
erotizing1949963erotizing
flatling123410013flatling
flatting123511253flatting
fliting113514613flit_ing
flitting123010883flitting
floating123111883floating
floccing16306033floccing
flocking183410873flocking
flogging14329173flogging
flooding13238963flooding
flooring12259883flooring
flopping16388773flopping
flossing12247903flossing
flouring123010143flouring
flouting122610473flouting
flowing143411763flo_wing
fluting113815093flut_ing
flyting14378553flyt_ing
footing115017593foot_ing
footling12239923footling
frothing15208533frothing
futzing20307903_futzing
glazing183611003gl_azing
gloaming12268013gloaming
gloating102611463gloating
globing113210003glo_bing
glomming14275923glomming
glooming12358013glooming
glopping14307753glopping
glorying1335543glorying
glossing10278883glossing
glouting10379693glouting
gloving12308443glo_ving
glowing123211793glo_wing
glutting10247643glutting
hooting113919883hoot_ing
hotting113116523_hotting
jolting153410913jolt_ing
jotting152912773_jotting
knotting13236573knotting
lathing114315693_lathing
lazing164821473_l_azing
letting83218533_letting
loading94114613_loading
loafing11319793_loafing
loaming103613733_loaming
loaning83614833_loaning
loathing1247673_loathing
lobbing123110913_lobbing
locking143718153_locking
locoing102810973_locoing
lodging103110813_lodging
lofting113311313_lofting
logging103316803_logging
loiding93313403_loiding
lolling83415773_lolling
longing93915783_longing
looing73621043_lo_oing
looking123415043_looking
looming102814853_looming
looping103615283_looping
loosing83515963_loosing
looting83019643_looting
loping93921413_lo_ping
lopping123815223_lopping
lording93115233_lording
losing74022873_lo_sing
louping104313983_louping
louring83916503_louring
lousing83817733_lousing
louting83719383_louting
loving104416723_lo_ving
lowing104623273_lo_wing
loxing143615273_lo_xing
luting75221753_lut_ing
molting103517173molt_ing
mooting103019363moot_ing
nothing113511903_nothing
noting74120153_not_ing
oozing163812203__oozing
panting104025423pant_ing
parting103527383part_ing
partying14168893partying
pasting103826553past_ing
patting103722343p_atting
pectizing2348013pectizing
pelting102917273pelt_ing
peopling1338353peopling
peptizing2347113peptizing
pestling111010253pestling
petting103720953p_etting
pettling1168213pettling
phoning13312053pho_ning
phonying1745833phonying
picoting1338883picot_ing
pilotings1234353pilot_ings
pithing134014053p_ithing
pitting103618873p_itting
pitying132910243p_itying
pivoting1436183pivot_ing
placing123815283pl_acing
plaguing1236033plaguing
plaining113911553plaining
plaiting113113513plaiting
planing103418253pl_aning
planking153513013planking
planning113610223planning
planting113515383planting
plashing143311063plashing
platina94413643plat_ina
platings113611363plat_ings
playing133816093pl_aying
plaything1843853plaything
pleading123011443pleading
pleasing112611593pleasing
pleating112916053pleating
pledging13276363pledging
plinking153611243plinking
plotlines1146823plotlines
plottier10327263plottier
plotties103111413plotties
plotz164617003plotz___
plotzed19376223plotz_ed
plotzes18317703plotz_es
ploughing16203673ploughing
plucking17357723plucking
plugging13306893plugging
plumbing15286433plumbing
pluming123412043pl_uming
plumping15277633plumping
plunging12357673plunging
plunking15328483plunking
plying124312083pl__ying
pocking163916763p_ocking
podding124113183p_odding
poetizing2148683poetizing
poising103617103p_oising
poking133819303p_o_king
policing13311673policing
poling93526503p_o_ling
polkaing1534633polkaing
polling102920383p_olling
poncing122913583p_oncing
ponding114317083p_onding
ponging113416153p_onging
ponying133312123p_onying
pooching16328983pooching
poohing133112323p_oohing
pooing93820683p_o_oing
pooling103219093p_ooling
pooping123615443p_ooping
popping113715413p_opping
poring94227273p_o_ring
porking143515813p_orking
porting103021783p_orting
posing93922643p_o_sing
posting105622243p_osting
potline91015233p_otline
pouring103115863p_ouring
pouting103519943p_outing
poxing163714943p_o_xing
prating103424453prat_ing
prizing193514683p_rizing
probing123314443pro_bing
prodding13189343prodding
progging132610383progging
promoing13310463promoing
pronging123511843pronging
proofing1439313proofing
propping122811673propping
prosing103319383pro_sing
protein92414733protein_
proteins102114283proteins
proving134214073pro_ving
prowling1449993prowling
punting103318443punt_ing
putting103218573p_utting
puttying1434953puttying
quoting17310043quot_ing
replotting1357043replotting
rioting82716393riot_ing
rooting83522433root_ing
rootling9269953rootling
rotting82919683_rotting
shotting123012383shotting
slating83724653slat_ing
slatting94014233slatting
slitting93012583slitting
slogging113410493slogging
sloping104114073slo_ping
slopping133811423slopping
sloshing12258823sloshing
slowing112814743slo_wing
snoozing18319083snoozing
soothing12269973soothing
sooting82820963soot_ing
splatting1235983splatting
splitting1236563splitting
splodging1433303splodging
sploshing1544293sploshing
splotching1842863splotching
spotting112812093spotting
spritzing2135393spritzing
stotting92811163stotting
swotting12268483swotting
toothing12278863toothing
tooting83019423toot_ing
tootling9279523tootling
toting74123793_tot_ing
totting82816843_totting
trothing122410843trothing
trotting92510913trotting
uploading1334663uploading
voting103916033_vot_ing
waltzing2134263waltzing
wotting112913843_wotting

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.1561145455.1
2DLD Change Limit1461622817.86018595.7
3Display Results2812810.1102554.5
 (SQL Overall)1786912818.12621990.0
 
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.