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

468 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
stotting9281116(None) 
shotting123012381shotting
slotting92612611slotting
spotting112812091spotting
stetting93410711stetting
swotting12268481swotting
totting82816841_totting
blotting113910432blotting
clotting113110642clotting
dotting93314482_dotting
hotting113116522_hotting
jotting152912772_jotting
knotting13236572knotting
lotting82917752_lotting
plotting113011012plotting
potting103720892_potting
rotting82919682_rotting
scatting113311812scatting
scooting113012642scooting
scouting112612752scouting
setting83621392s_etting
shitting123212662shitting
shooting122812862shooting
shorting122514802shorting
shouting122711792shouting
shutting12309692shutting
sitting83519632s_itting
slatting94014232slatting
slitting93012582slitting
smutting11278062smutting
snooting92813202snooting
snorting92613372snorting
snouting92511922snouting
soothing12269972soothing
sooting82820962s_ooting
sorting83221812s_orting
spatting113111762spatting
spitting113012322spitting
sporting112415462sporting
spouting113511952spouting
starting93116172starting
stating83725162st_ating
stilting93312402stilting
stinting93415742stinting
stobbing13227242stobbing
stocking152912502stocking
stodging11277462stodging
stoking123615592sto_king
stomping13309762stomping
stoning83717442sto_ning
stooging102810042stooging
stooking132711142stooking
stooling93113132stooling
stooping113012362stooping
stoping103716622sto_ping
stopping133611412stopping
storing83921122sto_ring
storming11209422storming
storying12249672storying
stotin63215062sto_tin_
stotins73213872sto_tins
stowing113315132sto_wing
strutting1037002strutting
stunting92811502stunting
swatting12309592swatting
tatting84019522_tatting
toiting83217092_toiting
tooting83019422_tooting
toting74123792_to_ting
touting84118452_touting
trotting92510912trotting
tutting83515912_tutting
wotting112913842_wotting
abetting1158293abetting
aborting11710253aborting
abutting1137003abutting
adopting1237453adopting
allotting1046503allotting
assorting1037303assorting
astonying1345233astonying
atoning83514873ato_ning
batting104422273_batting
besotting12256873besotting
betting103921403_betting
bitting103717293_bitting
blatting114111653blatting
bloating113512813bloating
boating103721303_boating
bolting104416763_bolting
boosting113311053boosting
booting103821363_booting
bottling11279143bottling
butting103519283_butting
catting103922643_catting
chatting142810143chatting
clothing14278783clothing
clouting113011683clouting
coating103525313_coating
coopting133411313coopting
costing104323023_costing
coting94629253_co_ting
cutting103817493_cutting
distorting1239593distorting
doating93816863_doating
doting84821913_do_ting
dratting10389663dratting
duetting1047183duetting
emitting112410353emitting
emoting10313563emo_ting
escorting1237713escorting
escoting1158713esco_ting
estating92614993est_ating
estopping1434793estopping
extorting1746763extorting
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
intorting10311413intorting
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
mottling11197753mottling
netting84018763_netting
notating92513343notating
nothing113511903_nothing
noting74120153_no_ting
nutting83316233_nutting
omitting11217743omitting
opting94514403__opting
outing74128153__outing
patting103722343_patting
petting103720953_petting
photoing1439073photoing
pitting103618873_pitting
platting114813033platting
plotzing20276153plotzing
porting103021783_porting
posting105622243_posting
pouting103519943_pouting
putting103218573_putting
quitting18228833quitting
quoiting1836093quoiting
quoting17310043quo_ting
ratting83822363_ratting
repotting12511123repotting
respotting1347113respotting
retorting10613273retorting
retting83425883_retting
rioting82716393rio_ting
roosting93411463roosting
rooting83522433_rooting
rootling9269953rootling
rotating92614553rotating
routing83821093_routing
rutting82718043_rutting
sainting93215733sainting
salting84120793s_alting
saluting9310553saluting
satiating10311813satiating
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
situating1038883situating
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
sopiting11310763sopiting
sopping123917203s_opping
sorbing102815263s_orbing
soring74731883s_o_ring
sorning83116813s_orning
sottish10129443s_ottish
souping104215533s_ouping
souring83219063s_ouring
sousing83517823s_ousing
southing122811823southing
sowing104222913s_o_wing
spirting112913633spirting
spiting103917623s_piting
splatting1235983splatting
splitting1236563splitting
spoiling112911553spoiling
spoking143212223spo_king
sponging1238823sponging
spoofing14228363spoofing
spooking15269803spooking
spooling113212563spooling
spooning112811443spooning
spooring113111463spooring
sporing104319413spo_ring
spottier10207313spottier
spottily1335153spottily
spousing11198733spousing
spoutings12245153spoutings
sprouting1236943sprouting
spurting113111633spurting
squatting1934513squatting
stabbing13238763stabbing
stabling112913653stabling
stacking154215083stacking
staffing15247493staffing
stagging113310513stagging
staging93818373st_aging
staining9413373staining
staking123919803st_aking
staling83925423st_aling
stalking133512223stalking
stalling95116703stalling
stamping133310963stamping
standing103413633standing
stanging104013653stanging
staning83922243st_aning
stapling112813153stapling
staring84527053st_aring
starling93017123starling
starring92312953starring
startling1037373startling
starving122510173starving
stashing123511583stashing
statin63921473st_atin_
statins73719773st_atins
staving113915703st_aving
staying114017323st_aying
steading103613593steading
stealing93416603stealing
steaming114013213steaming
steeking133411353steeking
steeling93615143steeling
steeping113412583steeping
steering93916793steering
steeving12359653steeving
stemming13408203stemming
stepping13329073stepping
sterling93615553sterling
stewing113412493st_ewing
sticking153513463sticking
stiffing15248703stiffing
stifling122110913stifling
stilling93415323stilling
stimying1437503stimying
sting65330243s___ting
stinging103213453stinging
stinking133113543stinking
stirring9299653stirring
stitching1547103stitching
stithying1643703stithying
stockings16296093stockings
stoppling1474963stoppling
stotinka1241563sto_tinka
stotinki1241673sto_tinki
stotinov1142063sto_tinov
stott56929793stott___
stotted83511423stott_ed
stotts64612863stott__s
stounding1136233stounding
stouten7307333stouten_
stoutening1143383stoutening
stoutens8255273stoutens
stoutish1145903stoutish
strafing122111193strafing
strawing122411623strawing
straying122912693straying
strewing12289853strewing
striating10914193striating
striding102713603striding
striking133012233striking
string75327563s__tring
striping112612523striping
striving122611393striving
stroking132610943stroking
strolling10238793strolling
stropping1436933stropping
strouding1136373strouding
strowing122310563strowing
stroying122410593stroying
strunting1037873strunting
stubbing13237453stubbing
studding1136703studding
studying1335553studying
stuffing15247843stuffing
stumming13347673stumming
stumping13289083stumping
stunning9298463stunning
stuttering1196353stuttering
stying105414573s__tying
styling112910653st_yling
stymying1733963stymying
suiting83419003s_uiting
swathing15248713swathing
sweating123213023sweating
sweeting123911313sweeting
swobbing16235173swobbing
swooning12278203swooning
swooping14338403swooping
swopping16377963swopping
swouning12246563swouning
tarting84222653_tarting
tasting84624213_tasting
tattings9408823_tattings
tattling9259473_tattling
tauting83316383_tauting
tenting84621153_tenting
testing86021053_testing
tilting83417103_tilting
tinting84620603_tinting
tithing113513893_tithing
titling83715793_titling
toasting93410583_toasting
toeing74418473_to_eing
togging103512743_togging
toiling83219023_toiling
toking114420723_to_king
toling73926123_to_ling
tolling83418563_tolling
tombing123310533_tombing
tomming12359243_tomming
tonging93314513_tonging
toning74025793_to_ning
tontine72316143_tontine
tooling82918313_tooling
toothing12278863toothing
tootling9279523tootling
toping94122993_to_ping
topping123514623_topping
tossing83612563_tossing
totaling9610303_totaling
tottering10229613_tottering
touring82915193_touring
tousing82916993_tousing
towing103823193_to_wing
toying105017303_to_ying
trothing122410843trothing
tufting11289873_tufting
twitting12307223twitting
tything14316573_tything
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.420425454.8
2DLD Change Limit1461624686.64022012.3
3Display Results4684680.1902463.2
 (SQL Overall)1786914687.25024647.0
 
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.