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

493 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
doolees8371161(None) 
doolee73018951doolee_
doolies83920711doolies
bootees94114472bootees
cooees85621892coo_ees
coolers93522492coolers
coolies93824962coolies
coulees9315502coulees
dholes104914792dhol_es
dhoolies1246962dhoolies
doglegs1034782doglegs
doilies84017362doilies
doles67843752d_ol_es
dollies83620982dollies
donees74519492d_onees
donnees84210362donnees
doobies103915672doobies
doodies94218772doodies
doodlers10338842doodlers
doodles93614162doodles
doolie73916832doolie_
doorless936712doorless
doozers17419292doozers
doozies173812722doozies
doyleys14384922doyleys
doylies114512572doylies
mooleys1236862mooleys
pollees93215332pollees
poolers94217422poolers
toolers74416502toolers
woolens10398842woolens
woolers104214022woolers
woolies104117362woolies
adoptees1145123adoptees
allees64521483_allees
amoles84122193amol_es
anoles64827423anol_es
apogees1037103apogees
azoles154614613azol_es
bailees93914383bailees
bogles95020833bogl_es
boilers93417063boilers
boles75448603_bol_es
boletes9316063_boletes
boobies113718203boobies
boodies103721443boodies
boodlers113710743boodlers
boodles103416043boodles
boogers104514633boogers
boogeys13476873boogeys
boogies103719013boogies
bookers134016613bookers
bookies133819403bookies
booklets14247123booklets
boomers114115913boomers
boomlets12246673boomlets
boonies93422483boonies
boonless10328353boonless
bootee84323023bootee_
booties94124613booties
bootlegs11325873bootlegs
bootless103410983bootless
boozers183912443boozers
boozes174916523boo_zes
boules84925973boul_es
boulles93114123boulles
bowlegs13366813bowlegs
bowlers123715783bowlers
bowless123310313bowless
callees94117783callees
cholers124215203cholers
coalers94419353coalers
coatees93816553coatees
cobles104622883cobl_es
coffees15329573coffees
coilers93619903coilers
coles76055063_col_es
coleus86818273_coleus
colies84837053_colies
colleen939533colleen
colleens1036843colleens
colleges112410513colleges
collets93517903collets
collies94326583collies
colones96124433colones
congees103517923congees
cooches143515833cooches
cooee74531023coo_ee_
cooeed95917863coo_eed
cooers84324563coo_ers
cooeys114914483coo_eys
cookers134619463cookers
cookeys16478503cookeys
cookies133719273cookies
cookless14258633cookless
cooled95224583cool_ed
cooler84824713cool_er
coolest9318643coolest
coolie83821603coolie_
coolness1037743coolness
cools75632633cool__s
coolths1236013coolths
coombes133810663coombes
coopers114019483coopers
cooters94525723cooters
cooties93725733cooties
corvees124613793corvees
coulee8323503coulee_
coxless1637743coxless
dailies84219263dailies
dales66439743d_al_es
dalles74222063d_alles
dallies84023193dallies
dealers84118613dealers
decrees102513123decrees
dees56356633d___ees
defleas1147223defleas
degrees92810723degrees
deles65139253d_el_es
deletes83117933d_eletes
dellies83622213dellies
delves104917083d_elves
depletes112810633depletes
devolves15286263devolves
devotees12286283devotees
dewless1137473dewless
dhole95215363dhol_e_
dhooties1237633dhooties
dialers83614303dialers
dillies84122163dillies
diocese1036853diocese
dioceses1137113dioceses
diodes83915783dio_des
diols65521013diol__s
diploes101111493diploes
dipoles101013753dipol_es
dobbers123513253dobbers
dobbies124113063dobbies
dobies94422093d_obies
doblas93812293dobl_as
doblones1136763doblones
doblons1037043doblons
dockers143715003dockers
dockets144412243dockets
dodders105511793dodders
dodgems12576443dodgems
dodgers105213823dodgers
dodges96119073d_odges
dodoes85716103d_odoes
doers65225713d_o_ers
does56554473d_o__es
doffers14359853doffers
doges75630163d_o_ges
dogeys115510663d_ogeys
doggers104413433doggers
doggies103613023doggies
dogies85022253d_ogies
dogleg936323dogl_eg
dogsleds1142913dogsleds
doiled84817293doil_ed
dolce85816683d_olce_
dole56550003d_ol_e_
doled75430913d_ol_ed
dollars83311023dollars
dolled83518073d_olled
dollied93811143dollied
dollops10287963dollops
dolls66126923d_ol_ls
dolmas95213043d_olmas
dolmen93911373d_olmen
dolmens10388693dolmens
dolors75115313d_olors
dolours8438823dolours
dols56943053d_ol__s
dolts65626313d_ol_ts
domes85735563d_o_mes
domines102918973domines
donates83217223donates
donee66931013d_onee_
dongles93212873dongles
donkeys15426663donkeys
donnee74317063donnee_
donzels1735393donzels
doobie94712683doobie_
doodads1035093doodads
doodle83212853doodle_
doodled10369463doodled
doodler93310153doodler
doodoos9107623doodoos
doofus1036163doo_fus
doofuses1244283doofuses
dooly94821803dool__y
doomed104113293doo_med
doomier103610123doomier
doomiest112910453doomiest
dooms85321343doo__ms
doormen1036753doormen
doors65022133doo__rs
doowops1363943doowops
doozer163910463doo_zer
doozie163910643doozie_
dopers95522483d_opers
dopes84935043d_o_pes
dories75232363d_ories
dormers104313923dormers
dorpers104113173dorpers
dorsels84412573dorsels
dorsers83516303dorsers
dosages92310803dosages
dosers75723633d_osers
doses65938503d_o_ses
dossels85511603dossels
dossers84516233dossers
dosses76126273d_osses
dotages92311793dotages
doters74423913d_oters
dotes65836693d_o_tes
dottels8327783dottels
dotters83715973dotters
dottles83912283dottles
doublers11288503doublers
doubles103113353doubles
doublets11257363doublets
douches134315233douches
doulas75114993doul_as
dousers84817273dousers
douses74928933d_ouses
dovens104413903d_ovens
doves94728153d_o_ves
dowdies123412733dowdies
doweled12269773doweled
dowels104813343d_owels
dowers104523293d_owers
downers113912773downers
downless1236363downless
dowries114413983dowries
dowsers115013533dowsers
dowses105718303d_owses
doxies143917853d_oxies
doyens104810223d_oyens
doyley13487283doyl_ey
dozens164612463d_ozens
dozers164815423d_ozers
dozes155226303d_o_zes
dragees9359483dragees
drawees11378363drawees
drees65628523d__rees
drogues9398393drogues
drolled93810223drolled
droller84110283droller
drollest937353drollest
drolls75312393drol_ls
droners84114383droners
drones75023433dro_nes
drooled9369203drool_ed
droolier936073droolier
drooliest1036343drooliest
drools74412813drool__s
droplets1136063droplets
drosses84513823drosses
drovers115212643drovers
droves105116673dro_ves
drowses114610233drowses
duelers83412053duelers
dulses73913653d_ulses
duologs935363duologs
duopolies1244323duopolies
duplexes1844043duplexes
egoless836983egoless
epopees1137233epopees
evolves13286743evolves
flees85828753__flees
fogless1138193fogless
foleys123810463_foleys
folles93820473_folles
follies103618943follies
foodies113416753foodies
foodless12338383foodless
fooled104317823fool_ed
fooleries1248743fooleries
foolery1336693foolery
fools86824203fool__s
footers104618333footers
footies103721543footies
footlers113910793footlers
footles103715713footles
footless113710803footless
foozlers20346073foozlers
foozles19329543foozles
fowlers133411203fowlers
gaolers83511563gaolers
gelees74116263_gelees
glees65027593__glees
goalies8316023goalies
goatees82710443goatees
goblets103210183goblets
godless938403godless
goglets9379783goglets
golems939323_golems
goobers10219623goobers
goodies93516993goodies
googlies1086763googlies
gooneys11407073gooneys
goonies83618333goonies
gooses75723053goo_ses
haoles94919803haol_es
holes84748653_hol_es
holies94630033_holies
hollers103818233hollers
hollies103420813hollies
holloes103818193holloes
honorees1148773honorees
hooches153812523hooches
hoodies113419833hoodies
hoodless12289733hoodless
hooeys125512313hoo_eys
hoofers134513323hoofers
hoofless14258013hoofless
hookers144916513hookers
hookeys17448953hookeys
hookies144017443hookies
hookless151238363hookless
hooklets15217203hooklets
hoolie93217773hoolie_
hoopers123616483hoopers
hoopless13279253hoopless
hoopoes121212483hoopoes
hooters104520463hooters
hoovers134312703hoovers
hooves124815483hoo_ves
howlers133312353howlers
howlets13329223howlets
hoyles12315013hoyl_es
jobless16237563jobless
joles125230833_jol_es
jollies143516273jollies
joules134116823joul_es
joyless17226513joyless
lees45455883___lees
lollers72713793lollers
lollies73116923lollies
loobies93814103loobies
looeys95110123loo_eys
looies65025833loo_ies
lookers114014073lookers
looneys10487013looneys
loonies73919543loonies
loopers93914033loopers
loosens716310953loosens
looses67328243loo_ses
looters74419163looters
mallees93315973mallees
melees83618083_melees
moilers93615203moilers
moles74747923_mol_es
molies84429513_molies
mollies93420233mollies
mooches143714453mooches
moolahs12347383moolahs
moolas83615593mool_as
mooley11311633mool_ey
mools76027173mool__s
mooners94015343mooners
mooneyes1396113mooneyes
moonless10278043moonless
moonlets10247473moonlets
mooters93818623mooters
motleys1235683motleys
nobles83319723nobl_es
noodges9317703noodges
noodles83513193noodles
noogies82814583noogies
nookies113414963nookies
noosers74913923noosers
nooses65623643noo_ses
oboles83815833obol_es
odorless934173odorless
odyles10348563odyl_es
ogees65119143__ogees
oglers74313183_oglers
ogles65223183_ogl_es
oilers64721193_oilers
oleos55419683__oleos
oles46453473__ol_es
oodles73517183_oodles
oolites72817843_oolites
oozes145418713_oo_zes
orles55326213_orl_es
owlets93110393_owlets
parolees104313973parolees
piolets93513193piolets
poleis86018353_poleis
polers84225643_polers
poles75351003_pol_es
polies84034583_polies
pollee83623273pollee_
pollens93713303pollens
pollers93420023pollers
pongees104212543pongees
pooches143214163pooches
poodles103013513poodles
pooled94619813pool_ed
pooler83819843pool_er
pools74427703pool__s
pooves113914713poo_ves
posoles9314883posol_es
pozoles1839063pozol_es
prolegs10379993prolegs
proles84627203prol_es
robles85321693robl_es
rodless8310073rodless
roles56747983_rol_es
rollers73117473rollers
roofers105013903roofers
roofies103014413roofies
roofless11316733roofless
rookies113917103rookies
roomers95416413roomers
roomies93017243roomies
roosers74217873roosers
rooses65526233roo_ses
rooters74522933rooters
rootles73215633rootles
rootless83910443rootless
rootlets8308653rootlets
scoleces1237073scoleces
socles8418453socl_es
soirees72411643soirees
soles55547923_sol_es
soleus64615613_soleus
solves95018223_solves
sonless72612613sonless
sooners73916643sooners
soothes103917103soothes
spoolers10349363spoolers
stoles63927673stol_es
stoolies8311083stoolies
tholes94919783thol_es
toeless72612393toeless
toffees13327083toffees
toilers74116263toilers
toiles63923513toil_es
toilets74112913toilets
toles55147133_tol_es
tollers73217463tollers
tonlets73212503tonlets
tooled74918903tool_ed
tooler63818613tool_er
toolless836343toolless
tools55325243tool__s
toonies73719883toonies
tooters73818773tooters
tootlers8289503tootlers
tootles72915603tootles
tootses72910773tootses
topees85519703_topees
topless92511123topless
toupees938513toupees
towhees13277793towhees
townees10269783townees
toyless10268713toyless
violets102210003violets
voiles94616443voil_es
voles86234043_vol_es
volleys13316643volleys
voltes94915583_voltes
vowless13246603vowless
wholes124616773whol_es
whoopees16294823whoopees
wolves124510853_wolves
woodies113517153woodies
woodless12278453woodless
wooers93712443woo_ers
woofers133810583woofers
wooled103715503wool_ed
woolen93111373wool_en
wooler93615873wool_er
woolie93514483woolie_
woolier103612353woolier
wooliest113011643wooliest
woolled1136643woolled
woollen1034723woollen
woollens1144093woollens
woollies1147413woollies
woolmen1234973woolmen
wools84421463wool__s
woopses1237883woopses
wooshes13169883wooshes
yodlers11298923yodlers
yodles103714333yodl_es
yogees10510633_yogees
yowlers13328923yowlers
zoogleas1843373zoogleas

Search took 9 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.1561145455.1
2DLD Change Limit1340274938.34316064.6
3Display Results4934930.1862650.5
 (SQL Overall)1786914938.68520574.7
 
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.