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

439 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
blotting11391043(None) 
blatting114111651blatting
bloating113512811bloating
clotting113110641clotting
lotting82917751_lotting
plotting113011011plotting
slotting92612611slotting
allotting1046502allotting
batting104422272b_atting
besotting12256872besotting
betting103921402b_etting
bitting103717292b_itting
blasting114013432blasting
bleating113514502bleating
blitzing2035902blitzing
blobbing12246922blobbing
blocking174510572blocking
blogging13369012blogging
blooding122410652blooding
blooming13299432blooming
blooping13248842blooping
blotching1734962blotching
blottier10336412blottier
blousing1138792blousing
blowing133813052blo_wing
blunting11319842blunting
blurting11258772blurting
boating103721302b_oating
bolting104416762b_olting
boosting113311052boosting
booting103821362b_ooting
bottling11279142b_ottling
butting103519282b_utting
clothing14278782clothing
clouting113011682clouting
dotting93314482_dotting
flatting123511252flatting
flitting123010882flitting
floating123111882floating
flouting122610472flouting
gloating102611462gloating
glouting10379692glouting
glutting10247642glutting
hotting113116522_hotting
jotting152912772_jotting
knotting13236572knotting
letting83218532_letting
lofting113311312_lofting
looting83019642_looting
louting83719382_louting
platting114813032platting
plotzing20276152plotzing
potting103720892_potting
rotting82919682_rotting
shotting123012382shotting
slatting94014232slatting
slitting93012582slitting
spotting112812092spotting
stotting92811162stotting
swotting12268482swotting
totting82816842_totting
trotting92510912trotting
wotting112913842_wotting
abetting1158293abetting
ablating11312003abl_ating
aborting11710253aborting
abutting1137003abutting
adopting1237453adopting
alerting91312383alerting
baiting103918883b_aiting
balloting1238393balloting
bantling112612003bantling
basting104227203b_asting
bathing134816243b_athing
bating95132253b__ating
battings114010573b_attings
battling113110493battling
batwing13509813b_atwing
beating104326873b_eating
beclothing1843873beclothing
beetling1139283beetling
befitting15236623befitting
begetting13186583begetting
beknotting1782813beknotting
belittling1343193belittling
belonging1335913belonging
belting104119133b_elting
berating113220763berating
berthing14209603berthing
besetting12268423besetting
besting104923923b_esting
bighting15269453bighting
billeting1236643billeting
biotin83215833bio_tin_
biotins93114453bio_tins
birthing14338433birthing
biting95321823b__iting
bittings11339293b_ittings
blabbing12266723blabbing
blacking174213603blacking
blading113615363bl_ading
blagging13319173blagging
blaming123515693bl_aming
blanking154411933blanking
blaring104317113bl_aring
blastings12347913blastings
blattering13108723blattering
blawing134012753bl_awing
blazing193612393bl_azing
blearing113111943blearing
blebbing12265673blebbing
bleeding12359053bleeding
bleeping13377933bleeping
blending12249963blending
blessing1137593blessing
blighting1635733blighting
blinding123210163blinding
blinking153510623blinking
blipping15306803blipping
blissing1136873blissing
bloggings14264263bloggings
blondine1137153blondine
bloodings13245273bloodings
bloodying1643783bloodying
blotted103911833blott_ed
blotter94612853blott_er
blotters104110983blotters
blottiest11286833blottiest
blotto8198443blott__o
blotty11178343blott__y
bloviating1643813bloviating
blubbing12257013blubbing
bludging13297463bludging
blueing103710203bl_ueing
bluffing17275493bluffing
bluing94914483bl__uing
bluming123511283bl_uming
blunging12328413blunging
blurbing13326503blurbing
blurring11277233blurring
blushing14339333blushing
boasting113512503boasting
boatings113710113b_oatings
bobbing113113193b_obbing
boding104320063b_o_ding
bodying1438973b_odying
boffing16339983b_offing
bogging123615753b_ogging
boiling103819673b_oiling
boing84725553b_o__ing
bolling103820883b_olling
bombing143211393b_ombing
bonding113318433b_onding
bonging113316373b_onging
boning94223293b_o_ning
bonking144116373b_onking
boobing123613913b_oobing
boodling121910243boodling
boogying1535373boogying
booing94521643b_o_oing
booking143618383b_ooking
booming123716223b_ooming
boozing194012163b_oozing
bopping143512033b_opping
borating113414503borating
boring94724873b_o_ring
borking144716173b_orking
bossing103714603b_ossing
botching16359703b_otching
bottlings12215293b_ottlings
bottoming1444433b_ottoming
bousing103718043b_ousing
bowing124723063b_o_wing
bowling133916493b_owling
bowsing134012503b_owsing
boxing163915153b_o_xing
boycotting1842633boycotting
brattling1236003brattling
brittling1235543brittling
broiling113112013broiling
broking143514823bro_king
bromating1439183bromating
bronzing2037693bronzing
brooding122911373brooding
brooking153710703brooking
brooming132911143brooming
browning14299643browning
browsing14319353browsing
bruiting11259973bruiting
bruting102612993b_ruting
bulleting1236643bulleting
bunting103718833b_unting
buoying13379953buo_ying
bursting1138703bursting
busting104221793b_usting
bustling112110063bustling
butling103516813b_utling
catting103922643_catting
chatting142810143chatting
cleating113518143cleating
clefting14347583clefting
cloaking15299713cloaking
clocking174312413clocking
clogging13368503clogging
clomping15329653clomping
cloning103215473clo_ning
clonking153810153clonking
clopping153511083clopping
closeting1236183closeting
closing103114843clo_sing
clothings15264433clothings
cloturing1245473cloturing
clouding12269493clouding
clouring112811273clouring
clowning14307253clowning
cloying133511753clo_ying
coating103525313_coating
coopting133411313coopting
coplotting1555953coplotting
costing104323023_costing
coting94629253_co_ting
cutting103817493_cutting
doating93816863_doating
doting84821913_do_ting
dratting10389663dratting
duetting1047183duetting
elating83423083el_ating
electing112113783electing
eloining9310443eloining
eloping103512833elo_ping
eluting84115293el_uting
emitting112410353emitting
emoting10313563emo_ting
fatting113818703_fatting
fetting113517873_fetting
fitting113516563_fitting
flatling123410013flatling
fleeting122910323fleeting
flinting123412343flinting
flirting12319013flirting
fliting113514613fl_iting
floccing16306033floccing
flocking183410873flocking
flogging14329173flogging
flooding13238963flooding
flooring12259883flooring
flopping16388773flopping
flossing12247903flossing
flouring123010143flouring
flowing143411763flo_wing
fluting113815093fl_uting
flyting14378553fl_yting
footing115017593_footing
footling12239923footling
fretting122711523fretting
fritting123510703fritting
fronting12310443fronting
frosting12311183frosting
frothing15208533frothing
garotting1136113garotting
gavotting1443193gavotting
getting93316563_getting
ghosting1336463ghosting
gitting93215703_gitting
gleeting10279173gleeting
glinting103210053glinting
glitzing1934973glitzing
gloaming12268013gloaming
globing113210003glo_bing
glomming14275923glomming
glooming12358013glooming
glopping14307753glopping
glorying1335543glorying
glossing10278883glossing
glottic1036653glotti_c
glottis837173glotti_s
gloving12308443glo_ving
glowing123211793glo_wing
glozing18338893glo_zing
gritting10309983gritting
grouting103410793grouting
gutting93415923_gutting
hatting113920233_hatting
hitting113017273_hitting
hooting113919883_hooting
hosting114318383_hosting
hutting113016033_hutting
inletting1087873inletting
jetting153815343_jetting
jolting153410913_jolting
jottings16275193_jottings
jutting153313713_jutting
kitting123214443_kitting
knitting13257023knitting
knottings14243073knottings
knouting13226793knouting
lasting84725243_lasting
lathing114315693_lathing
lattin64316223_lattin_
lattins74115483_lattins
lifting113313273_lifting
lilting83515383_lilting
linting83820983_linting
listing84020593_listing
loading94114613_loading
loafing11319793_loafing
loaming103613733_loaming
loaning83614833_loaning
loathing1247673_loathing
lobbing123110913_lobbing
locating11311503_locating
locking143718153_locking
locoing102810973_locoing
lodging103110813_lodging
logging103316813_logging
loiding93313403_loiding
lolling83415783_lolling
longing93915783_longing
looing73621043_lo_oing
looking123415043_looking
looming102814853_looming
looping103615283_looping
loosing83515963_loosing
loping93921413_lo_ping
lopping123815223_lopping
lording93115233_lording
losing74022873_lo_sing
louping104313983_louping
louring83916503_louring
lousing83817733_lousing
loving104416723_lo_ving
lowing104623273_lo_wing
loxing143615273_lo_xing
lunting83817743_lunting
lusting83619323_lusting
luting75221753_l_uting
matting103620143_matting
moating104218153_moating
molting103517173_molting
mooting103019363_mooting
mottling11197753_mottling
netting84018763_netting
notating92513343_notating
nothing113511903_nothing
noting74120153_no_ting
nutting83316233_nutting
omitting11217743omitting
opting94514403__opting
outing74128153__outing
patting103722343_patting
petting103720953_petting
photoing1439073photoing
piloting1139693pilo_ting
pitting103618873_pitting
plaiting113113513plaiting
planting113515383planting
plating103823073pl_ating
pleating112916053pleating
plodding13166343plodding
plonking15358563plonking
plopping12318703plopping
plotline1037643plotline
plottier10327263plottier
plotties103111413plotties
plowing133111723plo_wing
ploying132811573plo_ying
porting103021783_porting
posting105622243_posting
pouting103519943_pouting
putting103218573_putting
quitting18228833quitting
quoiting1836093quoiting
quoting17310043quo_ting
ratting83822363_ratting
reletting102713943reletting
replotting1357043replotting
repotting12511123repotting
retting83425883_retting
rioting82716393rio_ting
roosting93411463roosting
rooting83522433_rooting
rootling9269953rootling
rotating92614553_rotating
routing83821093_routing
rutting82718043_rutting
scatting113311813scatting
scooting113012643scooting
scouting112612753scouting
setting83621393_setting
shitting123212663shitting
shooting122812863shooting
shorting122514803shorting
shouting122711793shouting
shutting12309693shutting
sitting83519633_sitting
slanting94115093slanting
slating83724653sl_ating
slattings10346073slattings
sleeting93114163sleeting
slogging113410493slogging
sloping104114073slo_ping
slopping133811423slopping
sloshing12258823sloshing
slowing112814743slo_wing
smutting11278063smutting
snooting92813203snooting
snorting92613373snorting
snouting92511923snouting
solating9315593solating
soothing12269973soothing
sooting82820963_sooting
sorting83221813_sorting
spatting113111763spatting
spitting113012323spitting
splatting1235983splatting
splitting1236563splitting
sporting112415463sporting
spouting113511953spouting
stetting93410713stetting
subletting1346273subletting
swatting12309593swatting
tabletting1344093tabletting
tatting84019523_tatting
toiting83217093_toiting
toothing12278863toothing
tooting83019423_tooting
tootling9279523tootling
toting74123793_to_ting
touting84118453_touting
trothing122410843trothing
tutting83515913_tutting
twitting12307223twitting
vatting113614853_vatting
vetting114216563_vetting
voting103916033_vo_ting
wetting114117383_wetting
whetting1535973whetting
witting113417063_witting
wonting113214103_wonting

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 Filter1786911461620.466383457.1
2DLD Change Limit1461624397.11020557.2
3Display Results4394390.1732537.6
 (SQL Overall)1786914397.74923059.9
 
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.