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

479 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
spotting11281209(None) 
potting103720891_potting
shotting123012381shotting
slotting92612611slotting
spatting113111761spatting
spitting113012321spitting
sporting112415461sporting
spouting113511951spouting
stotting92811161stotting
swotting12268481swotting
blotting113910432blotting
clotting113110642clotting
dotting93314482_dotting
hotting113116522_hotting
jotting152912772_jotting
knotting13236572knotting
lotting82917752_lotting
patting103722342_patting
petting103720952_petting
pitting103618872_pitting
plotting113011012plotting
porting103021782_porting
posting105622242_posting
pouting103519942_pouting
putting103218572_putting
repotting12511122repotting
respotting1347112respotting
rotting82919682_rotting
scatting113311812scatting
scooting113012642scooting
scouting112612752scouting
setting83621392s_etting
shitting123212662shitting
shooting122812862shooting
shorting122514802shorting
shouting122711792shouting
shutting12309692shutting
sitting83519632s_itting
slatting94014232slatting
slitting93012582slitting
smutting11278062smutting
snooting92813202snooting
snorting92613372snorting
snouting92511922snouting
soothing12269972soothing
sooting82820962s_ooting
sopiting11310762sopiting
sorting83221812s_orting
spirting112913632spirting
spiting103917622sp_iting
splatting1235982splatting
splitting1236562splitting
spoiling112911552spoiling
spoking143212222spo_king
sponging1238822sponging
spoofing14228362spoofing
spooking15269802spooking
spooling113212562spooling
spooning112811442spooning
spooring113111462spooring
sporing104319412spo_ring
spottier10207312spottier
spottily1335152spottily
spousing11198732spousing
spoutings12245152spoutings
sprouting1236942sprouting
spurting113111632spurting
stetting93410712stetting
swatting12309592swatting
totting82816842_totting
trotting92510912trotting
wotting112913842_wotting
abetting1158293abetting
aborting11710253aborting
abutting1137003abutting
adopting1237453adopting
allotting1046503allotting
assorting1037303assorting
batting104422273_batting
besotting12256873besotting
betting103921403_betting
bitting103717293_bitting
blatting114111653blatting
bloating113512813bloating
boating103721303_boating
bolting104416763_bolting
boosting113311053boosting
booting103821363_booting
bottling11279143_bottling
butting103519283_butting
catting103922643_catting
chatting142810143chatting
clothing14278783clothing
clouting113011683clouting
coating103525313_coating
coopting133411313coopting
coplotting1555953coplotting
costing104323023_costing
coting94629253_co_ting
cutting103817493_cutting
deporting1369593deporting
disporting1439823disporting
doating93816863_doating
doting84821913_do_ting
dratting10389663dratting
duetting1047183duetting
emitting112410353emitting
emoting10313563emo_ting
epoxying2133033epoxying
escorting1237713escorting
escoting1158713esco_ting
espousing1265003espousing
exporting1937323exporting
fatting113818703_fatting
fetting113517873_fetting
fitting113516563_fitting
flatting123511253flatting
flitting123010883flitting
floating123111883floating
flouting122610473flouting
footing115017593_footing
footling12239923footling
fretting122711523fretting
fritting123510703fritting
fronting12310443fronting
frosting12311183frosting
frothing15208533frothing
garotting1136113garotting
gavotting1443193gavotting
getting93316563_getting
ghosting1336463ghosting
gitting93215703_gitting
gloating102611463gloating
glouting10379693glouting
glutting10247643glutting
gritting10309983gritting
grouting103410793grouting
gutting93415923_gutting
hatting113920233_hatting
hitting113017273_hitting
hooting113919883_hooting
hosting114318383_hosting
hutting113016033_hutting
importing1438193importing
imposting1436813imposting
inputting1235823inputting
jetting153815343_jetting
jolting153410913_jolting
jottings16275193_jottings
jutting153313713_jutting
kitting123214443_kitting
knitting13257023knitting
knottings14243073knottings
knouting13226793knouting
letting83218533_letting
lofting113311313_lofting
looting83019643_looting
louting83719383_louting
matting103620143_matting
moating104218153_moating
molting103517173_molting
mooting103019363_mooting
mottling11197753_mottling
netting84018763_netting
notating92513343_notating
nothing113511903_nothing
noting74120153_no_ting
nutting83316233_nutting
omitting11217743omitting
opiating11410093opiating
opting94514403__opting
outing74128153__outing
panting104025423_panting
parting103527383_parting
pasting103826553_pasting
pelting102917273_pelting
pettings11349703_pettings
pettling1168213_pettling
photoing1439073photoing
pipetting1435513pipetting
pithing134014053_pithing
pittings11349123_pittings
pitying132910243_pitying
plating103823073_plating
platting114813033platting
plotzing20276153plotzing
pocking163916763_pocking
podding124113183_podding
pointing112813683_pointing
poising103617103_poising
poking133819303_po_king
poling93526503_po_ling
polling102920383_polling
poncing122913583_poncing
ponding114317083_ponding
ponging113416153_ponging
pontine92419053_pontine
ponying133312123_ponying
poohing133112323_poohing
pooing93820683_po_oing
pooling103219093_pooling
pooping123615443_pooping
popping113715413_popping
poring94227273_po_ring
porking143515813_porking
posing93922643_po_sing
positing11312303_positing
postin83521033_postin_
postings112912303_postings
postins93721203_postins
potline91015233_potline
pottering122612003_pottering
pottier93516493_pottier
potties93723543_potties
pouring103115863_pouring
poutine93316823_poutine
poxing163714943_po_xing
prating103424453_prating
punting103318443_punting
puttying1434953_puttying
putzing19359123_putzing
quitting18228833quitting
quoiting1836093quoiting
quoting17310043quo_ting
ratting83822363_ratting
replotting1357043replotting
reporting12513903reporting
retting83425883_retting
rioting82716393rio_ting
riposting1236063riposting
roosting93411463roosting
rooting83522433_rooting
rootling9269953rootling
rotating92614553_rotating
routing83821093_routing
rutting82718043_rutting
sainting93215733sainting
salting84120793s_alting
saluting9310553saluting
sating74735453s__ating
sauteing937913sauteing
scanting113914763scanting
scarting113415263scarting
scathing14269703scathing
scenting113212813scenting
scoffing17275943scoffing
scolding12278913scolding
sconcing1338263sconcing
scooping133610633scooping
scoping123513823sco_ping
scoring103117213sco_ring
scorning1169133scorning
scotching1735653scotching
scottie937463scotti_e
scotties1039753scotties
scouring112810853scouring
scoutings12306143scoutings
scowing133812093sco_wing
scowling1458293scowling
scuttling1234243scuttling
scything17264883scything
seating84130683s_eating
sedating103014113sedating
seething1239023seething
settings93810073s_ettings
settling978943settling
shafting15278683shafting
sheeting122712833sheeting
shifting152910383shifting
shirting123213613shirting
shoaling123111753shoaling
shocking184311543shocking
shoeing113211883sho_eing
shogging14308023shogging
shooing112112913sho_oing
shooling123012563shooling
shootings13266063shootings
shopping163611293shopping
shoring112820073sho_ring
shotten10288463shotten_
shoving142910643sho_ving
showing143814663sho_wing
showring1548323showring
shunting123610433shunting
shuting113212053s_huting
shuttling1334293shuttling
sifting113014593s_ifting
sighting133110863sighting
silting83320483s_ilting
siting74126623s__iting
sittings9339733s_ittings
skating123613853s_kating
skirting13289393skirting
skiting123812503s_kiting
skoaling13227213skoaling
slanting94115093slanting
slating83724653s_lating
slattings10346073slattings
sleeting93114163sleeting
slogging113410493slogging
sloping104114073slo_ping
slopping133811423slopping
sloshing12258823sloshing
slowing112814743slo_wing
smarting113212453smarting
smelting11339713smelting
smiting103014443s_miting
smocking17349103smocking
smoking143210523smo_king
smoothing1535293smoothing
snogging11318043snogging
snooding102910433snooding
snooking133010583snooking
snooling93013473snooling
snooping113811323snooping
snoozing18319083snoozing
snoring83917203sno_ring
snottier8217383snottier
snottily1145553snottily
snowing113913453sno_wing
soaking123116613s_oaking
soaping103616223s_oaping
soaring83521893s_oaring
sobbing127612883s_obbing
socking143518603s_ocking
sodding103712733s_odding
soiling83422323s_oiling
solating9315593solating
soling74226823s_o_ling
soloing82813803s_oloing
solving112910853s_olving
sopping123917203s_opping
sorbing102815263s_orbing
soring74731883s_o_ring
sorning83116813s_orning
sottish10129443s_ottish
souping104215533s_ouping
souring83219063s_ouring
sousing83517823s_ousing
southing122811823southing
sowing104222913s_o_wing
spacing123614493sp_acing
spading113114383sp_ading
spaeing103413543sp_aeing
spalling113213463spalling
spamming15317603spamming
spanking153911973spanking
spanning113311083spanning
sparging122611133sparging
sparing104823873sp_aring
sparking152812543sparking
sparling112714533sparling
sparring113112223sparring
spartina1037983spartina
spasming13227203spasming
spattering13107793spattering
spawning14296913spawning
spaying133014623sp_aying
speaking153212493speaking
speaning113512243speaning
spearing113216103spearing
speccing15306643speccing
specking17359733specking
spectating1546623spectating
speeding122810933speeding
speeling112713123speeling
speering113116323speering
speiling113612973speiling
speiring113711263speiring
spelling113315233spelling
spending122712433spending
spewing133110453sp_ewing
sphering142811943sphering
spicing123914533sp_icing
spieling113212523spieling
spiering112713353spiering
spiffing17237083spiffing
spiking144312883sp_iking
spiling102919703sp_iling
spilling113113943spilling
spinning113310813spinning
spiring103918183sp_iring
spiriting1238413spiriting
splaying14219303splaying
splicing1338963splicing
splining11310773splining
splinting1238193splinting
splodging1433303splodging
sploshing1544293sploshing
splotching1842863splotching
spoliating1366963spoliating
spongin1036373spongin_
spongins1136563spongins
spoolings12245393spoolings
sportier102010053sportier
sportif1238803sporti_f
sportily1337733sportily
sportingly1645543sportingly
sportive1348333sportive
spotlit947303spotli_t
spotted103713143spott_ed
spotter94514883spott_er
spotters104313383spotters
spottiest11177693spottiest
spottiness1285763spottiness
spotty11448583spott__y
sprattling1363053sprattling
spraying14299883spraying
spring94526013sp__ring
sprinting12310033sprinting
spritzing2135393spritzing
sprucing1336893sprucing
spudding1335653spudding
spuing94313363sp__uing
spuming1248523sp_uming
spunking15258063spunking
spurning11258663spurning
spurring11339763spurring
sputtering13106463sputtering
spying123913253sp__ying
squatting1934513squatting
starting93116173starting
stating83725163s_tating
stilting93312403stilting
sting65330243s___ting
stinting93415743stinting
stobbing13227243stobbing
stocking152912503stocking
stodging11277463stodging
stoking123615593sto_king
stomping13309763stomping
stoning83717443sto_ning
stooging102810043stooging
stooking132711143stooking
stooling93113133stooling
stooping113012363stooping
stoping103716623sto_ping
stopping133611413stopping
storing83921123sto_ring
storming11209423storming
storying12249673storying
stotin63215063sto_tin_
stotins73213873sto_tins
stowing113315133sto_wing
string75327563s__tring
strutting1037003strutting
stunting92811503stunting
stying105414573s__tying
suiting83419003s_uiting
supporting1545563supporting
swathing15248713swathing
sweating123213023sweating
sweeting123911313sweeting
swobbing16235173swobbing
swooning12278203swooning
swooping14338403swooping
swopping16377963swopping
swouning12246563swouning
tatting84019523_tatting
toiting83217093_toiting
toothing12278863toothing
tooting83019423_tooting
tootling9279523tootling
toting74123793_to_ting
touting84118453_touting
trothing122410843trothing
tutting83515913_tutting
twitting12307223twitting
updating1236593updating
uprating11311113uprating
uprooting1276903uprooting
upsetting1275563upsetting
vatting113614853_vatting
vetting114216563_vetting
voting103916033_vo_ting
wetting114117383_wetting
whetting1535973whetting
witting113417063_witting
wonting113214103_wonting

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.486367677.0
2DLD Change Limit1461624797.68619016.7
3Display Results4794790.3901228.2
 (SQL Overall)1786914798.56220870.2
 
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.