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

294 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
doyleys1438492(None) 
doyley13487281doyley_
dogeys115510662do_geys
doglegs1034782doglegs
doles67843752do_le_s
donkeys15426662donkeys
doolees83711612doolees
doyens104810222doy_ens
doylies114512572doylies
doyly124514012doyl_y_
foleys123810462fo_leys
hoyles12315012hoyle_s
joyless17226512joyless
mooleys1236862mooleys
motleys1235682motleys
odyles10348562odyle_s
toyless10268712toyless
volleys13316642volleys
alleys95113303_alleys
baileys12388933baileys
barleys125011843barleys
bogeys124510913bo_geys
bogles95020833bogle_s
boilers93417063boilers
boles75448603bo_le_s
boogeys13476873boogeys
boules84925973boule_s
bowlegs13366823bowlegs
bowlers123715783bowlers
bowless123310313bowless
boylas113011723boyl_as
burleys12479673burleys
chyles144813283chyle_s
coalers94419353coalers
cobles104622883coble_s
coilers93619903coilers
colbys13407153co_lbys
coles76055063co_le_s
coleus86818273co_leus
collets93517903collets
coneys115218423co_neys
conveys15308223conveys
cooeys114914483co_oeys
cookeys16478503cookeys
coolers93522493coolers
coseys115215813co_seys
coulees9315513coulees
coveys145413503co_veys
coxless1637743coxless
coyly135614893coyl_y_
coyness1277323coyness
cozeys204610913co_zeys
dales66439743d_ale_s
dalles74222063dalle_s
darkeys15356533darkeys
daybeds14234473daybeds
dealers84118613dealers
defleas1147223defleas
delays104014053d_elays
deles65139253d_ele_s
deploys1336523deploys
dewless1137473dewless
deys85027473d___eys
dholes104914793dhole_s
dialers83614303dialers
dickeys17479303dickeys
diddleys14334633diddleys
dingeys12458403dingeys
dinkeys15507263dinkeys
dobbers123513253dobbers
dobies94422093dobie_s
doblas93812293dobl_as
doblons1037043doblons
dockers143715003dockers
dockets144412243dockets
dodders105511793dodders
dodgems12576443dodgems
dodgers105213823dodgers
dodges96119083dodge_s
dodoes85716103dodoe_s
doers65225713do__ers
does56554473do__e_s
doffers14359853doffers
doges75630163do_ge_s
dogey105719513do_gey_
doggers104413433doggers
dogies85022253dogie_s
dogleg936323dogle_g
dogsleds1142913dogsleds
doiled84817293doile_d
doilies84017363doilies
doily95321033doil_y_
dole56550003do_le__
doled75430913do_le_d
dollars83311023dollars
dolled83518073dolle_d
dollies83620983dollies
dollops10287963dollops
dolls66126923do_l_ls
dolly96125203do_lly_
dolmas95213043do_lmas
dolmens10388693dolmens
dolors75115313do_lors
dols56943053do_l__s
dolts65626313do_l_ts
domes85735563do_me_s
donees74519493do_nees
dongles93212873dongle_s
donkey14449733donkey_
donnees84210363donnees
donzels1735393donzels
doodlers10338843doodlers
doodles93614163doodle_s
doolee73018953doole_e
doolies83920713doolies
dooly94821803dool_y_
doorless936713doorless
doozers17419293doozers
dopers95522483do_pers
dopes84935043do_pe_s
dopey116020353do_pey_
dories75232363dorie_s
dormers104313923dormers
dorpers104113173dorpers
dorsels84412583dorsels
dorsers83516303dorsers
dosers75723633do_sers
doses65938503do_se_s
dossels85511613dossels
dossers84516233dossers
dosses76126273dosse_s
doters74423913do_ters
dotes65836693do_te_s
dottels8327783dottels
dotters83715973dotters
dottles83912283dottle_s
doublers11288503doublers
doubles103113353double_s
doublets11257363doublets
doulas75114993doul_as
dousers84817273dousers
douses74928933douse_s
dovekeys1941723dovekeys
dovens104413903do_vens
doves94728153do_ve_s
dowels104813343do_wels
dowers104523293do_wers
downers113912773downers
downless1236363downless
dowsers115013533dowsers
dowses105718303dowse_s
doxies143917853doxie_s
doyen95014413doy_e_n
dozens164612463do_zens
dozers164815423do_zers
dozes155226303do_ze_s
droplets1136063droplets
dryers10449273dry_ers
drylots1143743drylots
dryly12538453dryl_y_
dryness11114783dryness
duelers83412053duelers
dyers96617133d_y_ers
dyes85331893d_y_e_s
dykes135215573d_yke_s
dykey16608673d_ykey_
dynels10536813d_ynels
dynes95917583d_yne_s
fleys117015603__fleys
flyless1335003flyless
fogeys13509263fo_geys
fogless1138193fogless
foley115222303fo_ley_
folles93820473folle_s
fowlers133411203fowlers
foyers125413133foy_ers
galleys11369713galleys
gleys96514853__gleys
goblets103210183goblets
godless938403godless
goglets9379783goglets
golems939323go_lems
gooneys11407073gooneys
gulleys11438523gulleys
henleys1334843henleys
heydeys1732863heydeys
hockeys19509273hockeys
holes84748653ho_le_s
holey115626903ho_ley_
hollers103818233hollers
homeys145012883ho_meys
honeys124016083ho_neys
honkeys17439513honkeys
hooeys125512323ho_oeys
hookeys17448963hookeys
hoseys124614013ho_seys
howlers133312353howlers
howlets13329223howlets
hoydens14347403hoydens
hoyle11314413hoyle__
hurleys13407333hurleys
jobless16237563jobless
jockeys23365953jockeys
joeys15518043jo__eys
joles125230833jo_le_s
joules134116823joule_s
kayles134712003kayle_s
keyless1436163keyless
leys76430183___leys
lollers72713793lollers
looeys95110123lo_oeys
looneys10487013looneys
medleys13115333medleys
moilers93615203moilers
moles74747923mo_le_s
moneys115513623mo_neys
monkeys16407423monkeys
mooley11311633mooley_
moseys114711713mo_seys
motley1139383motley_
muleys11409643_muleys
mulleys12299203mulleys
nobles83319723noble_s
obeys107010643_o_beys
odorless934173odorless
odyle9349593odyle__
odyls9428653odyl__s
odysseys154793odysseys
oglers74313183_oglers
ogles65223183_ogle_s
oilers64721193_oilers
oleos55419683_o_leos
oles46453473_o_le_s
onlays9398713_onlays
oodles73517183oodle_s
orles55326213_orle_s
owlets93110393_owlets
oyers87620883_oy_ers
oyes74940133_oy_e_s
parleys125212373parleys
pogeys124110353po_geys
pokeys15529513po_keys
poleis86018353po_leis
polers84225643po_lers
poles75351003po_le_s
poleyn1157323po_leyn
poleyns1236113po_leyns
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
polys105718763po_l_ys
poolers94217423poolers
pulleys12399143pulleys
pusleys12286233pusleys
rayless10239003rayless
ridleys11145783ridleys
robles85321693roble_s
rodless8310073rodless
roles56747983ro_le_s
rollers73117473rollers
smileys12336323smileys
socles8418453socle_s
soles55547923so_le_s
soleus64615613so_leus
sonless72612613sonless
stylers10359353stylers
styles94418653style_s
stylets10369213stylets
toeless72612393toeless
toilers74116263toilers
toiles63923513toile_s
toilets74112913toilets
toles55147133to_le_s
tollers73217463tollers
tonlets73212503tonlets
toolers74416503toolers
topless92511123topless
toyers95516333toy_ers
trolleys11315693trolleys
valleys13407483valleys
voiles94616443voile_s
voles86234043vo_le_s
volley12419743volley_
vowless13246603vowless
waylays1634673waylays
wayless13308243wayless
woolens10398843woolens
woolers104214023woolers
wyles114615323_wyle_s
xylems1833203_xylems
ylems1039263__ylems
yodlers11298923yodlers
yodles103714333yodle_s
yowlers13328923yowlers

Search took 10 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.403443402.0
2DLD Change Limit1340272948.76615289.4
3Display Results2942940.1102672.7
 (SQL Overall)1786912949.27919257.6
 
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.