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

396 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
showring154832(None) 
shoring112820071sho_ring
showering1646401showering
showing143814661show_ing
showrings1644061showrings
choiring14279792choiring
choring133617662cho_ring
chowing164412772chow_ing
chowsing17217342chowsing
howking183610312_howking
howling143413162_howling
scoring103117212sco_ring
scouring112810852scouring
scowing133812092scow_ing
scowling1458292scowling
sharing113723242sh_aring
shawing143514882shaw_ing
shawling1558222shawling
shearing123915902shearing
sheering123715102sheering
shewing143812192shew_ing
shirring122910442shirring
shoaling123111752shoaling
shocking184311542shocking
shoeing113211882sho_eing
shogging14308022shogging
shooing112112912sho_oing
shooling123012562shooling
shooting122812862shooting
shopping163611292shopping
shorings12269482sho_rings
shorting122514802shorting
shotting123012382shotting
shouting122711792shouting
shoving142910642sho_ving
showings15246882show_ings
slowing112814742slow_ing
snoring83917202sno_ring
snowing113913452snow_ing
soaring83521892s_oaring
soring74731882s_o_ring
souring83219062s_ouring
sowing104222912s_ow_ing
spooring113111462spooring
sporing104319412spo_ring
storing83921122sto_ring
stowing113315132stow_ing
whoring142910292who_ring
abhorring1543543abhorring
adoring9412523ado_ring
ashlaring1344493ashlaring
ashlering1344153ashlering
avowing1466603avow_ing
behowling1843683behowling
blowing133813053blow_ing
boring94724873_bo_ring
bowering142911713_bowering
bowing124723063_bow_ing
bowling133916493_bowling
bowsing134012503_bowsing
browning14299643browning
browsing14319353browsing
chairing143110773chairing
charing133721323ch_aring
charring142913163charring
chawing164813033chaw_ing
cheering143612703cheering
chewing163911143chew_ing
chirring142610173chirring
chocking204011013chocking
choking173911943cho_king
chomping18339883chomping
choosing142010133choosing
chopping183710263chopping
chording15410153chording
chorine123218363cho_rine
chousing14259423chousing
chowdering2044163chowdering
churring14298653churring
clouring112811273clouring
clowning14307253clowning
cohering142413833cohering
coring94433963_co_ring
cowering142514033_cowering
cowing124526323_cow_ing
cowling134017423_cowling
crowding15247933crowding
crowing133814763crow_ing
crowning143510033crowning
dowering132510613_dowering
dowing114221513_dow_ing
downing123811673_downing
dowsing123411123_dowsing
drowning13298363drowning
drowsing13287773drowsing
flooring12259883flooring
flouring123010143flouring
flowering1636053flowering
flowing143411763flow_ing
fowling143713113_fowling
frowning15307833frowning
ghosting1336463ghosting
glowering1435653glowering
glowing123211793glow_ing
goring84119573_go_ring
gowning12258833_gowning
growing123512473grow_ing
growling1348163growling
haring104233003_h_aring
hawing134322353_haw_ing
hawking183711423_hawking
hearing113324163_hearing
heiring113312903_heiring
herring113615883_herring
hewing134514243_hew_ing
hiring104421603_h_iring
hoarding13288643_hoarding
hoaxing18307763_hoaxing
hobbing152811123_hobbing
hoboing13309453_hoboing
hocking173417243_hocking
hoeing104117023_ho_eing
hogging133112803_hogging
hoising113414413_hoising
hoking144419513_ho_king
holding123514283_holding
holing104025073_ho_ling
holking153512313_holking
homering141512073_homering
homing123718383_ho_ming
honing103421503_ho_ning
honking153414793_honking
honoring12310473_honoring
hooding123815203_hooding
hoofing143912553_hoofing
hooking153716693_hooking
hooping133615703_hooping
hooting113919883_hooting
hoping123719743_ho_ping
hopping154115273_hopping
hording123517053_hording
horning113015003_horning
horsing113215583_horsing
hosing103421103_ho_sing
hosting114318383_hosting
hotting113116523_hotting
housing113316523_housing
hovering151911143_hovering
howdying1933713_howdying
jowing174216043_jow_ing
knowing15287683know_ing
louring83916503_louring
lowering122210913_lowering
lowing104623273_low_ing
meowing1368593meow_ing
mooring102514443_mooring
mowing124119093_mow_ing
oaring74225303__oaring
owing96222723__ow_ing
owning104110333__owning
phoning13312053pho_ning
phonying1745833phonying
photoing1439073photoing
plowing133111723plow_ing
poring94227273_po_ring
pouring103115863_pouring
powering142210803_powering
prowling1449993prowling
pshawing1733523pshaw_ing
reshowering1843163reshowering
reshowing1646633reshow_ing
roaring82916003_roaring
rowing103623303_row_ing
sabering112113743sabering
sabring102614843s_abring
sacring103115983s_acring
savoring1269483savoring
savouring1335193savouring
sawing104323813s_aw_ing
scaring103421973s_caring
scarring112511513scarring
schooling1546943schooling
scoffing17275943scoffing
scolding12278913scolding
sconcing1338263sconcing
scooping133610633scooping
scooting113012643scooting
scoping123513823sco_ping
scorning1169133scorning
scourging1334573scourging
scourings12235293scourings
scouting112612753scouting
scowdering1743983scowdering
searing83330923s_earing
securing11310413securing
sering74731813s__ering
severing122013853severing
sewering122411093sewering
sewing103819623s_ew_ing
shacking184014083shacking
shading123115563sh_ading
shadowing1744263shadow_ing
shafting15278683shafting
shagging14349053shagging
shaking153317253sh_aking
shaming133016743sh_aming
shamming16289413shamming
shanking163612283shanking
shaping133116183sh_aping
sharking163912973sharking
sharping143011373sharping
shauling1249393shauling
shaving143414333sh_aving
sheafing15329483sheafing
shealing123415463shealing
shearings13337563shearings
shearling1336923shearling
sheaving154110253sheaving
shedding14278113shedding
sheening123010803sheening
sheeting122712833sheeting
shelling123515213shelling
shelving15278173shelving
shending132511253shending
shieling123512403shieling
shifting152910383shifting
shilling123315383shilling
shimming16278253shimming
shining113816523sh_ining
shinning123211023shinning
shipping163611253shipping
shirking163210473shirking
shirrings13245323shirrings
shirting123213613shirting
shitting123212663shitting
shivering1637333shivering
shmoozing2443613shmoozing
shoestring1444173shoestring
shootings13266063shootings
shoppings17295073shoppings
shoran94016043sho_ran_
shorans102812413sho_rans
shorn85722183sho_r_n_
shoveling1635553shoveling
showbiz2453223showbi_z
showcasing1942063showcasing
showgirl1542083showgirl
showier1339103show_ier
showily1636223show_ily
showman15257293showman_
showmen15227173showmen_
shown115216483show__n_
showroom1654063showroom
showtime1643773showtime
shrewing15228093shrewing
shrine94920053sh__rine
shrining122610853shrining
shrink134511733sh__rink
shriving15268453shriving
shroffing1943313shroffing
shrouding1434753shrouding
shucking18339433shucking
shunning12367843shunning
shunting123610433shunting
shushing15317743shushing
shuting113212053sh_uting
shutting12309693shutting
shying134211843sh__ying
siring75128313s__iring
skewering1744633skewering
skewing15318723skew_ing
skioring13237223skioring
skirring13297143skirring
skoaling13227213skoaling
slewing113311353slew_ing
slogging113410493slogging
sloping104114073slo_ping
slopping133811423slopping
sloshing12258823sloshing
slotting92612613slotting
slurring9288833slurring
smearing113511753smearing
smocking17349103smocking
smoking143210523smo_king
snaring83920953s_naring
snawing113612483snaw_ing
sneering93414503sneering
snogging11318043snogging
snooding102910433snooding
snooking133010583snooking
snooling93013473snooling
snooping113811323snooping
snooting92813203snooting
snoozing18319083snoozing
snorting92613373snorting
snouting92511923snouting
soaking123116613s_oaking
soaping103616223s_oaping
soarings93210393s_oarings
sobbing127612883s_obbing
sobering111912783sobering
socking143518603s_ocking
sodding103712733s_odding
soiling83422323s_oiling
soling74226823s_o_ling
soloing82813803s_oloing
solving112910853s_olving
soothing12269973soothing
sooting82820963s_ooting
sopping123917203s_opping
sorbing102815263s_orbing
sorings83817253s_o_rings
sorning83116813s_orning
sorting83221813s_orting
souping104215533s_ouping
sourcing1158353s_ourcing
sousing83517823s_ousing
sparing104823873s_paring
sparring113112223sparring
spawning14296913spawning
spearing113216103spearing
speering113116323speering
speiring113711263speiring
spewing133110453spew_ing
sphering142811943sphering
spiering112713353spiering
spiring103918183s_piring
spoiling112911553spoiling
spoking143212223spo_king
sponging1238823sponging
spoofing14228363spoofing
spooking15269803spooking
spooling113212563spooling
spooning112811443spooning
sporting112415463sporting
spotting112812093spotting
spousing11198733spousing
spouting113511953spouting
spring94526013s__pring
spurring11339763spurring
squaring18158633squaring
squiring18177563squiring
staring84527053s_taring
starring92312953starring
steering93916793steering
stewing113412493stew_ing
stirring9299653stirring
stobbing13227243stobbing
stocking152912503stocking
stodging11277463stodging
stoking123615593sto_king
stomping13309763stomping
stoning83717443sto_ning
stooging102810043stooging
stooking132711143stooking
stooling93113133stooling
stooping113012363stooping
stoping103716623sto_ping
stopping133611413stopping
storming11209423storming
storying12249673storying
stotting92811163stotting
string75327563s__tring
strowing122310563strow_ing
subring104116263s_ubring
sugaring1039053sugaring
supering11317683supering
suturing9310373suturing
swearing123711443swearing
swing96124843s__w_ing
swobbing16235173swobbing
swooning12278203swooning
swooping14338403swooping
swopping16377963swopping
swotting12268483swotting
swouning12246563swouning
thawing14378683thaw_ing
tholing112812333tho_ling
thorning1237513thorning
thouing11258603tho_uing
throwing1536723throw_ing
touring82915193_touring
towering122610873_towering
towing103823193_tow_ing
trowing113413703trow_ing
ushering1258923ush_ering
vowing133715273_vow_ing
whirring15286283whirring
whomping19285943whomping
whoofing18234833whoofing
whooping17286633whooping
whopping19357373whopping
wowing133915393_wow_ing
wring95920713___wring
yowing133715543_yow_ing
yowling143610223_yowling

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 Limit1461623966.95321021.4
3Display Results3963960.1732289.0
 (SQL Overall)1786913967.54623680.2
 
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.