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

353 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
welshes1337909(None) 
welches153710311welches
welshed14277201welshed
welsher13377441welsher
welshers14246811welshers
belches143514342belches
deashes113313902deashes
fleshes133913272fleshes
leashes103514402leashes
menshes12310452menshes
meshes115019442me_shes
relishes11311952relishes
reshes94124362re_shes
washes124425492w_ashes
welched16298832welched
welcher15319392welcher
welchers16338052welchers
wellies103719072wellies
welsh113110362welsh__
wenches152914132wenches
whishes16309442whishes
wishes124920952w_ishes
wooshes13169882wooshes
abashes12510373abashes
ashes86230613__ashes
bashes115631393_bashes
beaches144120653beaches
beeches143413883beeches
belched154011843belched
belcher143511493belcher
belchers153510023belchers
belies84631053bel_ies
belles85325993bel_les
bellies94023723bellies
benches143918603benches
beses75830723be_s_es
blesses93812393blesses
blushes124314823blushes
bolshies1338693bolshies
boshes114721883_boshes
brashes124518463brashes
brushes124014663brushes
bushes115226113_bushes
calashes13310543calashes
cashes114729883_cashes
ceases84427073ceas_es
celestes10310013celestes
censes83721803cens_es
cesses84221363ce_sses
clashes124017283clashes
coshes115022783_coshes
crashes124618403crashes
creeshes1336953creeshes
crushes124215133crushes
cuishes122810823cuishes
culches143710743culches
dashes106124983_dashes
deashed123411303deashed
delates83526283delates
deles65139253del__es
deletes83117933deletes
delimes10314193delimes
dellies83622213dellies
deludes91810643deludes
deluges9169263deluges
delves104917083del_ves
dishes104622653_dishes
dulses73913653duls_es
eases56041613_eas_es
easies64126633_easies
eches106322163_e_ches
elates65032363_elates
elides74420693_elides
elites66027123_elites
elopes85918163_elopes
else45923083_els_e_
eludes75417683_eludes
elutes64020313_elutes
elves85118743_el_ves
ensues63313813_ensues
erses55826803_ers_es
eses45336103_e_s_es
esnes54817363_e_snes
esses56422973_e_sses
etches114217763_etches
eyelashes1542853eyelashes
falsies103515013falsies
fashes124524023_fashes
feases95422923feas_es
feldsher1543243feldsher
feldshers1643093feldshers
felines104718073felines
fellies104119743fellies
felloes104114383felloes
felsites1138073felsites
fesses94820253fe_sses
fetches153413893fetches
fetishes1437153fetishes
filches153410723filches
fishes125221343_fishes
flashes133916103flashes
fleches153411443fleches
fleshed143210263fleshed
flesher133610923flesher
fleshers14339443fleshers
flushes134114143flushes
freshes133515823freshes
galoshes1236913galoshes
gashes105725153_gashes
geishas1135083geishas
gelates83219593gelates
gelees74116263gel_ees
gessoes838293gessoes
gestes75721393ge_stes
girshes11248293girshes
gnashes11419573gnashes
goloshes1236263goloshes
gulches13398113gulches
gurshes112210033gurshes
gushes104719033_gushes
hashes125024803_hashes
helices12313723helices
helixes1739133helixes
helloes103717463helloes
helves124316063hel_ves
hushes124718593_hushes
jellies143816533jellies
jesses135215953je_sses
joshes165114853_joshes
kellies113516853kellies
kelpies13289903kelpies
kelsons1137323kelsons
kenches163912273kenches
ketches164012193ketches
knishes1438263knishes
lashes94831003_lashes
leaches123319343leaches
leases65428113leas_es
leashed113211163leashed
leches115421313le_ches
leeches123911933leeches
lenses64620893lens_es
leses54930813le_s_es
lessees73510243lessees
letches124015483letches
lethes94818083le_thes
lushes94022743_lushes
marshes123615373marshes
mashes115030003_mashes
measles92412753measles
melees83618083mel_ees
mensches1536303mensches
menses84222453mens_es
menshen1236813menshen
merches144013763merches
meshed124415933me_shed
mesnes85216213me_snes
messes84924343me_sses
moshes115222873_moshes
mulches143210673mulches
mushes114124563_mushes
nellies73418723nellies
nelsons738003nelsons
nesses64718323ne_sses
newsies101310383newsies
noshes96618233_noshes
palsies94420273palsies
pashes115828393_pashes
peaches144120053peaches
peases85229473peas_es
peises84125043peis_es
pelages10714613pelages
peles75738083pel__es
pelisses1048483pelisses
pelites93821993pelites
pelves114514663pel_ves
pensees9311203pensees
perches143717953perches
perishes13313753perishes
perses85428063pers_es
pishes114722103_pishes
plashes124417393plashes
plushes124313673plushes
polishes13711783polishes
pulses83818663puls_es
pushes114621663_pushes
quashes192110973quashes
qurshes19228573qurshes
rashes95330153_rashes
reaches123423203reaches
rehashes1436953rehashes
relaces93420883relaces
relates73731433relates
relaxes143215323relaxes
releves103914973releves
relies65036423rel_ies
relines75331323relines
relished1239433relished
relives104619443relives
relumes9612513relumes
resees63827483re_sees
reshoes102316033re_shoes
retches123318513retches
reuses66025523reus_es
rewashes1447033rewashes
rushes94724363_rushes
sashes94728483_sashes
seethes103613743seethes
seiches12513813seiches
seises64026713seis_es
selahs9313213selah_s
selkies113513353selkies
selles64426983sel_les
selsyns1092943selsyns
selves94119613sel_ves
senses63923943sens_es
sepses84515883seps_es
shes75734353___shes
shushes133510303shushes
skoshes14246253skoshes
slashes103619113slashes
sloshes103811803sloshes
slushes103514413slushes
smashes123914613smashes
smushes123710093smushes
snashes105214753snashes
sneeshes1136513sneeshes
splashes1337503splashes
sploshes1336133sploshes
stashes103916173stashes
swashes134714403swashes
swishes133411373swishes
swooshes14185123swooshes
teaches122718353teaches
teases65426273teas_es
teethes103611653teethes
teles54536003tel__es
teleses7313123teleses
telexes1438353telexes
tellies73820503tellies
telomes9310533telomes
telpher1235563telpher
telphers1335473telphers
telsons739223telsons
tenches123515523tenches
tenses64722553tens_es
testes65125823te_stes
toshes94520103_toshes
trashes104119263trashes
tushes94319473_tushes
twelves1334303twel_ves
unlashes11238043unlashes
valses94514613vals_es
velites103417303velites
velures1039093velures
verses94223763vers_es
verstes104014283verstes
vetches153411263vetches
wales86142833wal__es
walies95324523wal_ies
wallies103320743wallies
waltzes1935953waltzes
warsles103413643warsles
washed135521503w_ashed
washer124720393w_asher
washers134517523w_ashers
wastes96224883w_astes
watches153017373watches
wealths13365813wealth_s
wearies103020223wearies
weasel93410523weas_el
weasels10468503weasels
weasons102310583weasons
weather133513223weather
weathers143412833weathers
weaves123616373we_aves
websites1335183websites
webster1236093webster
websters1335803websters
wechts1446253we_chts
wedges114614583we_dges
wedgies123910213wedgies
weenies102915093weenies
weepies122811743weepies
wees76249123we___es
weewees1336563weewees
weighed15135933weighed
weigher14136343weigher
weighers15135673weighers
weighs13338873weigh_s
weights14409553weights
welch134411493welch__
welcomes15134753welcomes
welded114013383wel_ded
welder102914413wel_der
welders113313413welders
weldless12285813weldless
weldors11238003weldors
welds94719163wel__ds
welfares1445543welfares
welkins1437173welkins
welled103820213wel_led
wellhead1543503wellhead
wellheads1653323wellheads
wellholes1544663wellholes
wellie92814913wellie_
wellness1135793wellness
wells85426193wel__ls
wellsites1244673wellsites
welshing15296523welshing
welted103715823wel_ted
welter93417383wel_ter
welters103516063welters
welts85225193wel__ts
wenched163910913wenched
wencher153811133wencher
wenchers16319213wenchers
wester94222893we_ster
westers105221963we_sters
wests85727003we_s_ts
wether123315393we_ther
wethers135214693we_thers
whished17428023whished
whishts16425313whishts
whooshes1734423whooshes
wiches144418753w_iches
wiles85437873wil__es
willies103920153willies
winches154714373winches
wises85633193w_is_es
wished134417513w_ished
wisher123617063w_isher
wishers133215213w_ishers
wisses94619603w_isses
witches152715793witches
withes124620843w_ithes
wolves124510853wol_ves
woolshed1553923woolshed
woolsheds1642553woolsheds
wooshed14167403wooshed
worses95522953wors_es
wrasses103812593wrasses
wreathes14299893wreathes
wrenches163210233wrenches
wretches16257283wretches
writhes134811703writhes
wusses93314893w_usses
wussies103411083wussies
wyches17387913w_yches
wyles114615323wyl__es
yeses85119323ye_s_es
yesses93615813ye_sses
zilches21326303zilches

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273536.00022337.8
3Display Results3533530.1402521.4
 (SQL Overall)1786913536.54627297.7
 
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.