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

445 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
skirting1328939(None) 
shirting123213611shirting
skirling13249061skirling
skirring13297141skirring
skirtings14274561skirtings
skiting123812501ski_ting
spirting112913631spirting
airting83616302_airting
flirting12319012flirting
girting93113332_girting
karting123716062_karting
kilting123213852_kilting
kirning12319332_kirning
kiting114117092_ki_ting
kitting123214442_kitting
quirting18238382quirting
sainting93215732sainting
scarting113415262scarting
shifting152910382shifting
shirking163210472shirking
shirring122910442shirring
shirtings13276602shirtings
shitting123212662shitting
shorting122514802shorting
sifting113014592s_ifting
silting83320482s_ilting
siring75128312s_ir_ing
siting74126622s_i_ting
sitting83519632s_itting
skating123613852sk_ating
skidding1535462skidding
skiing113610192ski__ing
skilling132911332skilling
skimming17286272skimming
skimping17306242skimping
skinking12299772skinking
skinning13327892skinning
skioring13237222skioring
skipping17297602skipping
skiving15298372ski_ving
slitting93012582slitting
smarting113212452smarting
smirking15277232smirking
smiting103014442smi_ting
snorting92613372snorting
sorting83221812s_orting
spiring103918182spir_ing
spiriting1238412spiriting
spiting103917622spi_ting
spitting113012322spitting
sporting112415462sporting
spurting113111632spurting
squirting1934792squirting
starting93116172starting
stilting93312402stilting
stinting93415742stinting
stirring9299652stirring
suiting83419002sui_ting
swirling12249142swirling
aborting11710253aborting
agisting1038243agisting
airing74927503_air_ing
airthing12297953_airthing
alerting91312383alerting
aspirating1348363aspirating
aspiring1138873aspir_ing
asserting1038663asserting
assisting1046183assisting
assorting1037303assorting
averting122512733averting
aviating12311013aviating
baiting103918883bai_ting
birding114014923_birding
birling104317053_birling
birring103713063_birring
birthing14338433_birthing
biting95321823_bi_ting
bitting103717293_bitting
blurting11258773blurting
carting104228283_carting
charting142614193charting
chirking18339383chirking
chirming16318643chirming
chirping16278863chirping
chirring142610173chirring
citing94220183_ci_ting
courting112514573courting
dairying1336353dairying
darting94020663_darting
dieting93616833_dieting
dinting93520553_dinting
dirking133812603_dirking
dirling93316073_dirling
dirtying1336093_dirtying
drifting13338733drifting
editing9313133edi_ting
emitting112410353emitting
escorting1237713escorting
everting122213133everting
evicting1437483evicting
eviting11511373evi_ting
exerting162211153exerting
existing1639073existing
exiting15311393exi_ting
fainting123312163fainting
fairing113614013fair_ing
farting114120753_farting
feinting123410833feinting
firing104021723_fir_ing
firming132811223_firming
fisting113818123_fisting
fitting113516563_fitting
flinting123412343flinting
fliting113514613fli_ting
flitting123010883flitting
foisting122910503foisting
fritting123510703fritting
gaiting93716583gai_ting
gifting123810893_gifting
girding103611883_girding
girning93210693_girning
girthing13256083_girthing
gitting93215703_gitting
glinting103210053glinting
grifting13299263grifting
gritting10309983gritting
hearting12513123hearting
heiring113312903heir_ing
heisting123411043heisting
hilting113316893_hilting
hinting113919223_hinting
hiring104421603_hir_ing
histing113720373_histing
hitting113017273_hitting
hoisting123610903hoisting
hurting113914033_hurting
iring66025423__ir_ing
irking114611753__irking
jilting153211743_jilting
jointing16248613jointing
joisting16328503joisting
kartings13418523_kartings
kerbing14308483_kerbing
kerfing15307533_kerfing
kerning124010893_kerning
kicking133314023_kicking
kidding14389773_kidding
killing123118723_killing
kilning12289023_kilning
kiltings13327083_kiltings
kinging133115033_kinging
kinking113615153_kinking
kipping163311873_kipping
kissing122911053_kissing
kithing153411553_kithing
kitling123313573_kitling
kittling1336063_kittling
knitting13257023knitting
lairing83715343lair_ing
lifting113313273_lifting
lilting83515383_lilting
linting83820983_linting
listing84020593_listing
marting103325013_marting
meriting11314683meriting
milting103619123_milting
minting103020813_minting
miring93723803_mir_ing
misting103623383_misting
mitring103514143_mitring
omitting11217743omitting
opiating11410093opiating
painting113614423painting
pairing103716733pair_ing
parting103527383_parting
pirating11314513_pirating
pitting103618873_pitting
pointing112813683pointing
porting103021783_porting
printing113216083printing
quieting18228463quieting
quilting18218713quilting
quiring17159993quir_ing
quirking22215123quirking
quitting18228833quitting
rifting113515003_rifting
rioting82716393_rioting
sabring102614843sabr_ing
sacring103115983sacr_ing
sailing83927373sai_ling
saining83621393sai_ning
salting84120793s_alting
saluting9310553saluting
satiating10311803satiating
sating74735453s__ating
scanting113914763scanting
scarfing14309713scarfing
scaring103421973scar_ing
scarping133312463scarping
scarring112511513scarring
scatting113311813scatting
scenting113212813scenting
scooting113012643scooting
scoring103117213scor_ing
scorning1169133scorning
scouting112612753scouting
scribing13238183scribing
scripting1437473scripting
scriving14258763scriving
scrying1338663s_crying
searing83330923sear_ing
seating84130683s_eating
secreting1279823secreting
sedating103014113sedating
seining84020773sei_ning
seising84018863sei_sing
seizing174114833sei_zing
serging93416673s_erging
seriating10916403seriating
sering74731813s_er_ing
serrating10513203serrating
serrying12167693serrying
serving113014983s_erving
setting83621393s_etting
shafting15278683shafting
sharing113723243shar_ing
sharking163912973sharking
sharping143011373sharping
sheeting122712833sheeting
shieling123512403shieling
shilling123315383shilling
shimming16278253shimming
shining113816523shi_ning
shinning123211023shinning
shipping163611253shipping
shirrings13245323shirrings
shirtier1137943shirtier
shooting122812863shooting
shoring112820073shor_ing
shotting123012383shotting
shouting122711793shouting
shrining122610853shrining
shriving15268453shriving
shunting123610433shunting
shuting113212053s_huting
shutting12309693shutting
sibling10814423s_ibling
siccing12319513s_iccing
sicking143720173s_icking
siding83822133s_i_ding
sidling9915423s_idling
sieging92613203s_ieging
sieving112311233s_ieving
siftings12236583s_iftings
sighing123311663s_ighing
sighting133110863sighting
signing92713963s_igning
silking123715593s_ilking
siloing83215503s_iloing
singing93221423s_inging
sinking123320543s_inking
sinning83918443s_inning
siping94220633s_i_ping
sipping123117433s_ipping
siruping1136503s_iruping
sittings9339733s_ittings
sizing163616443s_i_zing
skanking12288743skanking
skatings13326993sk_atings
skeeing12308853sk_eeing
skeining1347073skeining
skelping1535973skelping
skewing15318723sk_ewing
skidooing1562503skidooing
skiffling2043103skiffling
skiings12295733ski__ings
skijoring2142623skijoring
skillings14246133skillings
skimmings18243263skimmings
skiorings14243793skiorings
skirmish1743263skirmish
skirt95624663skirt___
skirted12388613skirt_ed
skirter11338483skirt_er
skirters12337243skirters
skirtlike1243003skirtlike
skirts104111503skirt__s
skittering1535393skittering
skittish1544503skittish
skivvying2391603skivvying
sklenting1475123sklenting
skoaling13227213skoaling
skulking12245903skulking
skulling13258103skulling
skunking12256653skunking
skying14399983sk__ying
skywriting2141933skywriting
slanting94115093slanting
slating83724653s_lating
slatting94014233slatting
sleeting93114163sleeting
slicing103514643sli_cing
slicking153712593slicking
sliding93114553sli_ding
slighting1436373slighting
sliming102913953sli_ming
slimming13288093slimming
slinging103312863slinging
slinking133412983slinking
sliping103314413sli_ping
slipping133510663slipping
slotting92612613slotting
slurping11278123slurping
slurring9288833slurring
smelting11339713smelting
smerking15258473smerking
smiling103915443smi_ling
smirching1744393smirching
smutting11278063smutting
snarfing12358663snarfing
snaring83920953snar_ing
snarling92513183snarling
snibbing13295893snibbing
snicking153610233snicking
sniffing15227453sniffing
sniping103712053sni_ping
snipping13308853snipping
snooting92813203snooting
snoring83917203snor_ing
snouting92511923snouting
soaring83521893soar_ing
soiling83422323soi_ling
solating9315593solating
sooting82820963s_ooting
sopiting11310763sopiting
sorbing102815263s_orbing
soring74731883s_or_ing
sorning83116813s_orning
sourcing1158353sourcing
souring83219063sour_ing
sparging122611133sparging
sparing104823873spar_ing
sparking152812543sparking
sparling112714533sparling
sparring113112223sparring
spartina1037983spartina
spatting113111763spatting
speiring113711263speir_ing
spicing123914533spi_cing
spieling113212523spieling
spiering112713353spiering
spiffing17237083spiffing
spiking144312883spi_king
spiling102919703spi_ling
spilling113113943spilling
spinning113310813spinning
spiraling1237953spiraling
splinting1238193splinting
splitting1236563splitting
sporing104319413spor_ing
spotting112812093spotting
spouting113511953spouting
spring94526013s_pr_ing
sprinting12310033sprinting
spritzing2135393spritzing
spurning11258663spurning
spurring11339763spurring
squinting1936223squinting
squiring18177563squir_ing
squirming2143223squirming
staring84527053star_ing
starling93017123starling
starring92312953starring
startling1037373startling
starving122510173starving
stating83725163s_tating
sterling93615553sterling
stetting93410713stetting
sticking153513463sticking
stiffing15248703stiffing
stifling122110913stifling
stilling93415323stilling
stimying1437503stimying
sting65330243s___ting
stinging103213453stinging
stinking133113543stinking
stirrings10224693stirrings
storing83921123stor_ing
storming11209423storming
storying12249673storying
stotting92811163stotting
striating10914193striating
striding102713603striding
striking133012233striking
string75327563s_tr_ing
striping112612523striping
striving122611393striving
stunting92811503stunting
subring104116263subr_ing
suitings9288953sui_tings
surfing112914483s_urfing
surging93115433s_urging
swarding1359003swarding
swarming1458223swarming
swatting12309593swatting
sweating123213023sweating
sweeting123911313sweeting
swerving1546113swerving
swigging14337223swigging
swilling123511933swilling
swimming16316323swimming
swinging133411113swinging
swinking163410323swinking
swiping13319823swi_ping
swishing15277813swishing
swiving14358953swi_ving
swotting12268483swotting
tainting93613583tainting
tarting84222653_tarting
thirling12248583thirling
thirsting1335283thirsting
tilting83417103_tilting
tinting84620603_tinting
tiring74023093_tir_ing
tirling83315733_tirling
toiting83217093toi_ting
twirling12246243twirling
twisting12427813twisting
twitting12307223twitting
uniting8315823uni_ting
wairing113414313wair_ing
waisting123615213waisting
waiting113618953wai_ting
weirding1335593weirding
whirling15237163whirling
whirring15286283whirring
whisting15329543whisting
whiting143311303whi_ting
wilting113515913_wilting
wiring104521023_wir_ing
wisting113519743_wisting
witing103522823_wi_ting
witting113417063_witting
writing113713893wri_ting
yirring11307763_yirring

Search took 7 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.423422437.4
2DLD Change Limit1461624456.32623105.0
3Display Results4454450.1732572.3
 (SQL Overall)1786914456.92225814.9
 
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.