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
showring154831(None) 
shoring112820061sho_ring
showering1646401showering
showing143814651show_ing
showrings1644061showrings
choiring14279782choiring
choring133617662cho_ring
chowing164412772chow_ing
chowsing17217342chowsing
howking183610312_howking
howling143413152_howling
scoring103117212sco_ring
scouring112810852scouring
scowing133812092scow_ing
scowling1458282scowling
sharing113723242sh_aring
shawing143514882shaw_ing
shawling1558222shawling
shearing123915902shearing
sheering123715102sheering
shewing143812192shew_ing
shirring122910442shirring
shoaling123111742shoaling
shocking184311532shocking
shoeing113211872sho_eing
shogging14308012shogging
shooing112112902sho_oing
shooling123012552shooling
shooting122812842shooting
shopping163611282shopping
shorings12269482sho_rings
shorting122514792shorting
shotting123012362shotting
shouting122711782shouting
shoving142910632sho_ving
showings15246882show_ings
slowing112814732slow_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
blowing133813043blow_ing
boring94724873_bo_ring
bowering142911713_bowering
bowing124723063_bow_ing
bowling133916483_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
cowling134017403_cowling
crowding15247933crowding
crowing133814763crow_ing
crowning143510033crowning
dowering132510603_dowering
dowing114221503_dow_ing
downing123811663_downing
dowsing123411113_dowsing
drowning13298363drowning
drowsing13287773drowsing
flooring12259873flooring
flouring123010143flouring
flowering1636053flowering
flowing143411753flow_ing
fowling143713103_fowling
frowning15307833frowning
ghosting1336463ghosting
glowering1435653glowering
glowing123211783glow_ing
goring84119573_go_ring
gowning12258833_gowning
growing123512473grow_ing
growling1348163growling
haring104233003_h_aring
hawing134322353_haw_ing
hawking183711423_hawking
hearing113324163_hearing
heiring113312903_heiring
herring113615873_herring
hewing134514243_hew_ing
hiring104421603_h_iring
hoarding13288643_hoarding
hoaxing18307763_hoaxing
hobbing152811123_hobbing
hoboing13309443_hoboing
hocking173417243_hocking
hoeing104117023_ho_eing
hogging133112803_hogging
hoising113414413_hoising
hoking144419513_ho_king
holding123514273_holding
holing104025063_ho_ling
holking153512303_holking
homering141512073_homering
homing123718383_ho_ming
honing103421503_ho_ning
honking153414793_honking
honoring12310453_honoring
hooding123815193_hooding
hoofing143912543_hoofing
hooking153716683_hooking
hooping133615693_hooping
hooting113919863_hooting
hoping123719733_ho_ping
hopping154115263_hopping
hording123517053_hording
horning113015003_horning
horsing113215583_horsing
hosing103421103_ho_sing
hosting114318383_hosting
hotting113116513_hotting
housing113316523_housing
hovering151911143_hovering
howdying1933713_howdying
jowing174216043_jow_ing
knowing15287673know_ing
louring83916503_louring
lowering122210913_lowering
lowing104623263_low_ing
meowing1368593meow_ing
mooring102514423_mooring
mowing124119093_mow_ing
oaring74225303__oaring
owing96222723__ow_ing
owning104110333__owning
phoning13312053pho_ning
phonying1745833phonying
photoing1439063photoing
plowing133111713plow_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
sconcing1338253sconcing
scooping133610623scooping
scooting113012633scooting
scoping123513813sco_ping
scorning1169133scorning
scourging1334573scourging
scourings12235293scourings
scouting112612753scouting
scowdering1743983scowdering
searing83330923s_earing
securing11310413securing
sering74731813s__ering
severing122013853severing
sewering122411093sewering
sewing103819623s_ew_ing
shacking184014083shacking
shading123115563sh_ading
shadowing1744263shadow_ing
shafting15278673shafting
shagging14349053shagging
shaking153317253sh_aking
shaming133016743sh_aming
shamming16289413shamming
shanking163612283shanking
shaping133116183sh_aping
sharking163912973sharking
sharping143011373sharping
shauling1249393shauling
shaving143414333sh_aving
sheafing15329483sheafing
shealing123415463shealing
shearings13337563shearings
shearling1336923shearling
sheaving154110253sheaving
shedding14278113shedding
sheening123010803sheening
sheeting122712823sheeting
shelling123515213shelling
shelving15278173shelving
shending132511253shending
shieling123512403shieling
shifting152910373shifting
shilling123315373shilling
shimming16278253shimming
shining113816523sh_ining
shinning123211023shinning
shipping163611253shipping
shirking163210473shirking
shirrings13245323shirrings
shirting123213603shirting
shitting123212653shitting
shivering1637333shivering
shmoozing2443593shmoozing
shoestring1444163shoestring
shootings13266053shootings
shoppings17295073shoppings
shoran94016033sho_ran_
shorans102812403sho_rans
shorn85722173sho_r_n_
shoveling1635553shoveling
showbiz2453203showbi_z
showcasing1942063showcasing
showgirl1542073showgirl
showier1339093show_ier
showily1636213show_ily
showman15257283showman_
showmen15227163showmen_
shown115216473show__n_
showroom1654033showroom
showtime1643733showtime
shrewing15228083shrewing
shrine94920053sh__rine
shrining122610853shrining
shrink134511733sh__rink
shriving15268453shriving
shroffing1943303shroffing
shrouding1434743shrouding
shucking18339433shucking
shunning12367843shunning
shunting123610423shunting
shushing15317743shushing
shuting113212043sh_uting
shutting12309683shutting
shying134211843sh__ying
siring75128313s__iring
skewering1744633skewering
skewing15318723skew_ing
skioring13237223skioring
skirring13297143skirring
skoaling13227203skoaling
slewing113311353slew_ing
slogging113410493slogging
sloping104114063slo_ping
slopping133811413slopping
sloshing12258823sloshing
slotting92612603slotting
slurring9288833slurring
smearing113511753smearing
smocking17349103smocking
smoking143210523smo_king
snaring83920953s_naring
snawing113612483snaw_ing
sneering93414503sneering
snogging11318043snogging
snooding102910433snooding
snooking133010583snooking
snooling93013463snooling
snooping113811313snooping
snooting92813193snooting
snoozing18319073snoozing
snorting92613373snorting
snouting92511923snouting
soaking123116613s_oaking
soaping103616213s_oaping
soarings93210393s_oarings
sobbing127612883s_obbing
sobering111912783sobering
socking143518603s_ocking
sodding103712733s_odding
soiling83422313s_oiling
soling74226813s_o_ling
soloing82813793s_oloing
solving112910843s_olving
soothing12269963soothing
sooting82820943s_ooting
sopping123917193s_opping
sorbing102815263s_orbing
sorings83817253s_o_rings
sorning83116813s_orning
sorting83221813s_orting
souping104215523s_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
spotting112812083spotting
spousing11198733spousing
spouting113511953spouting
spring94526013s__pring
spurring11339763spurring
squaring18158633squaring
squiring18177553squiring
staring84527053s_taring
starring92312953starring
steering93916793steering
stewing113412493stew_ing
stirring9299653stirring
stobbing13227243stobbing
stocking152912503stocking
stodging11277463stodging
stoking123615593sto_king
stomping13309763stomping
stoning83717443sto_ning
stooging102810043stooging
stooking132711143stooking
stooling93113133stooling
stooping113012353stooping
stoping103716613sto_ping
stopping133611413stopping
storming11209423storming
storying12249673storying
stotting92811153stotting
string75327563s__tring
strowing122310563strow_ing
subring104116263s_ubring
sugaring1039053sugaring
supering11317673supering
suturing9310373suturing
swearing123711443swearing
swing96124843s__w_ing
swobbing16235173swobbing
swooning12278203swooning
swooping14338393swooping
swopping16377963swopping
swotting12268473swotting
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
whooping17286623whooping
whopping19357373whopping
wowing133915393_wow_ing
wring95920713___wring
yowing133715543_yow_ing
yowling143610213_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.266671770.7
2DLD Change Limit1461623966.57622226.6
3Display Results3963960.1562538.5
 (SQL Overall)1786913966.99825534.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.