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

461 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
dapples123899(None) 
apples104315761_apples
dapple1138851dapple_
dappled1336391dappled
appels104312792_appels
apple94517672_apple_
applet105917432_applet
applets115710062_applets
applies11311212_applies
dabbles124514772dabbles
daddles104213802daddles
daggles103611912daggles
dales66439742da__les
dalles74222062da_lles
dandles94218532dandles
dangles93618422dangles
daphnes13327682daphnes
dapped124516762dapp_ed
dapper114016632dapp_er
darkles124011932darkles
dartles84014132dartles
dawdles12379162dawdles
dazzles1636412dazzles
dimples122813212dimples
dipoles101013752dipoles
fipples14298652fipples
grapples13348122grapples
hopples142810712hopples
maples104819422ma_ples
nappes104515622napp_es
nappies114613392nappies
nipples11319662nipples
pappies103214822pappies
papules112411572papules
popples103011872popples
rappees113611452rappees
rappels11448802rappels
ripples113513292ripples
samples112815452samples
supples11511282supples
tipples112811252tipples
topples113111652topples
abeles84719393_abeles
ables75935543_a_bles
addles84216603_addles
aisles64721143_aisles
ales47067103_a__les
ambles105121863_ambles
amoles84122193_amoles
ample94720303_ample_
ampler104313303_ampler
amplest11312333_amplest
ampules1189433ampules
aneles64626293_aneles
angles74426703_angles
ankles104818383_ankles
anoles64827433_anoles
apes66047433_a_p_es
apexes1539133_apexes
apices104916263_apices
appalls11337743_appalls
appals104812943_appals
appel94615893_app_el
applied1247483_applied
applier1137903_applier
appliers1235573_appliers
apply125111393_appl_y
appose10411993_appose
apposes11511473_apposes
apps86319693_app__s
appulse1134673_appulse
appulses1234893_appulses
apres75426403_a_pres
apses76823913_a_pses
argles75218483_argles
arles56735743_a_rles
axles125219473_a_xles
azoles154614613_azoles
babbles104416323babbles
baffles153710683baffles
bales76250083ba__les
bangles103617413bangles
battles94517683battles
baubles113611863baubles
buppies133011063buppies
cables104527553ca_bles
cackles153717203cackles
cajoles163712103cajoles
candles104422343candles
cantles94721413cantles
capelet11517073capelet
capelets1268603capelets
capes95441923ca_p_es
capizes20410373capizes
capless114312763ca_pless
caplet104226813ca_plet
caplets114914523ca_plets
capotes11314643capotes
capped134721853capp_ed
capper124421983capp_er
cappers134419403cappers
capsules1236623capsules
carles85435083ca_rles
carpels115315463carpels
castles94917733castles
caudles103912813caudles
caules85927253ca_ules
chappies172610093chappies
couples115317053couples
crappies142911153crappies
cripples14298403cripples
cupules113210263cupules
dabble114515193dabble_
dabbled133712073dabbled
dabbler124012153dabbler
dabblers13379363dabblers
daces85030683da__ces
dacites101114593dacites
daddies103414943daddies
daddle94214283daddle_
daddled113810743daddled
dadoes85616533da_does
daggle93711903daggle_
daggled11329463daggled
dagoes85714603da_goes
dahls95012283da_hl_s
dailies84219263dailies
dairies84217733dairies
daises74318983da_ises
daisies84217093daisies
dale55643983da__le_
dallies84023193dallies
dals57145123da__l_s
damages11511273damages
dames85435853da__mes
damped124315583damp_ed
dampen114310593damp_en
dampens12348563dampens
damper114117753damp_er
dampers123915693dampers
dampest12411043damp_est
damply14337893dampl_y
dampness1336073dampness
damps105220413damp__s
damsels10126703damsels
dances95120653da_nces
dandies94121443dandies
dandle84218093dandle_
dandled103313543dandled
dandler94414273dandler
dandlers103912053dandlers
dangle84119303dangle_
dangled104013153dangled
dangler96912813dangler
danglers103610593danglers
daphne12237013daphne_
dapperer1335763dapperer
dapperest1445283dapperest
dapping133714793dapping
dappling1436843dappling
daps77239163da_p__s
dapsones1138383dapsones
darbies104216983darbies
dares66146703da__res
darioles9710693darioles
darkies124015753darkies
darkle113813943darkle_
darkled13378723darkled
darnels83710433darnels
dartle73714833dartle_
dartled9409853dartled
dashes106124983da_shes
dassies84418663dassies
dateless9259963dateless
dates65639153da__tes
datives11310073datives
daubes94913703da_ubes
dauties83315763dauties
davies105020513da_vies
dawdle11399503dawdle_
dawdled13376723dawdled
dawdler12356793dawdler
dawdlers13375673dawdlers
dawties113312703dawties
dayflies1534463dayflies
dazes155024143da__zes
dazzle1536853dazzle_
dazzled1735033dazzled
dazzler1634713dazzler
dazzlers1733233dazzlers
deciles104417723deciles
deckles143312803deckles
decuples1395283decuples
defiles114016843defiles
deles65139253d__eles
depeoples1444223depeoples
depones103717093depones
deposes103117213deposes
deputes104911783deputes
dholes104914793d_holes
diazoles1836323diazoles
dibbles124013333dibbles
diddles103915073diddles
dimple113512793dimple_
dimpled132810303dimpled
dindles93817243dindles
dingles93818323dingles
diplex16408053d_iplex
diploes101111493diploes
dipole91112853dipole_
dipped123517493dipp_ed
dipper114017793dipp_er
dippers123615183dippers
dippier123111393dippier
dippiest132511133dippiest
dispels10310503dispels
doles67843753d__oles
dongles93212873dongles
doodles93614163doodles
dopes84935043d_op_es
dottles83912283dottles
doubles103113353doubles
drabbles13308523drabbles
draggles1145963draggles
drapes95419653drap_es
dripless1135243dripless
droplet10312113droplet
droplets1136063droplets
drupes94912653drup_es
duffles14308923duffles
dupes86425933d_up_es
duple85315863d_uple_
duplex16386973d_uplex
dupped124411643dupp_ed
eagles73819163ea_gles
empales112411433empales
examples1944313examples
fables114921673fa_bles
failles102914133failles
farles96025783fa_rles
fipple13329063fipple_
frappes14328383frapp_es
gabbles124415413gabbles
gables94222333ga_bles
gaggles103512593gaggles
gales65442483ga__les
gambles124016203gambles
gapes86030823ga_p_es
gapless10349993ga_pless
gapped124217123gapp_ed
gappier12369843gappier
gappiest13259473gappiest
garbles104016923garbles
gargles94214893gargles
grapple12378003grapple_
grappled14336093grappled
grappler13336193grappler
grapplers14274303grapplers
guppies123310523guppies
hackles162917063hackles
haggles123312483haggles
hales85449843ha__les
handles114020653handles
hantles104117513hantles
haoles94919803ha_oles
hapaxes1936593hapaxes
hapless123311333ha_pless
happed144820103happ_ed
happen134812193happ_en
happens14359173happens
happier143312033happier
happiest152411673happiest
harpies123818313harpies
hassles103411693hassles
hippies142813743hippies
hirples12149643hirples
hopple132910483hopple_
hoppled15338083hoppled
impales113311763impales
jacales16310323jacales
jangles154015683jangles
japes146322823ja_p_es
kales95730983ka__les
kappas144410363kapp_as
kayles134712003ka_yles
koppies153210013koppies
ladles74619543la_dles
lapeled10258893lapeled
lapels83712043lapel_s
lapides103012043lapides
lapises93513463lapises
lapped114320033lapp_ed
lapper104319953lapp_er
lappers113717463lappers
lappet103817723lapp_et
lappets11329123lappets
lapses85217693la_pses
mackles154415753mackles
macles107023223ma_cles
macules114015133macules
magpies12310363magpies
mailes84329113ma_iles
males75049793ma__les
mangles104021463mangles
maniples12269423maniples
mantles94820703mantles
maple95521143ma_ple_
mapped134015883mapp_ed
mapper124516093mapp_er
mappers133313783mappers
marbles114516653marbles
mayapples1841683mayapples
maypoles1545993maypoles
napalms1144033napalms
napes74828463na_p_es
napless93110283na_pless
nappas105511613napp_as
nappe96114993napp_e_
napped114218163napp_ed
napper103718283napp_er
nappers114214863nappers
nappie104112263nappie_
nappier114411173nappier
nappiest122510883nappiest
nipple103410373nipple_
nippled12307643nippled
nopales93812523nopales
paddles113515643paddles
padles95221123pa_dles
pales75753803__pales
pappier103511593pappier
pappiest112611113pappiest
pappose1047413pappose
pappous1057463pappous
pappus9408373papp_us
papule102212133papule_
parles86334403pa_rles
paroles95025883paroles
peles75738083__peles
peoples11312223peoples
piles74742613__piles
pimples133012423pimples
poles75351003__poles
poppies102816193poppies
popple92710983popple_
poppled11339243poppled
pules74538813__pules
puppies103212613puppies
purples112712833purples
rabbles113517973rabbles
raddles93615703raddles
raffles133611843raffles
raggles93813283raggles
rales54947493ra__les
rambles113118313rambles
rampoles1238893rampoles
rankles113114543rankles
rapes75740723ra_p_es
raphes115117453ra_phes
rapines95120863rapines
rapped114122683rapp_ed
rappee103618673rapp_ee
rappel104211953rapp_el
rappeled1335003rappeled
rappen103512713rapp_en
rapper104621573rapp_er
rappers113618443rappers
rassles73513923rassles
rattles73217303rattles
reapplies1344913reapplies
rimples113114223rimples
ripple103413913ripple_
rippled123110273rippled
rippler113210103rippler
ripplers12337113ripplers
ripplet113412583ripplet
ripplets12316733ripplets
rumples113313133rumples
sables85026693sa_bles
saddles95415743saddles
sales56055593sa__les
sample104215013sample_
sampled123410793sampled
sampler113212013sampler
samplers12299403samplers
sapless93313443sa_pless
sapotes9313943sapotes
sapped114422013sapp_ed
sapper103822353sapp_er
sappers113518903sappers
sappier113613113sappier
sappiest122612573sappiest
scrapples1534793scrapples
simples113014943simples
spales84728103_spales
spiles84227913_spiles
staples93617213staples
stipples1247023stipples
stopples1236953stopples
supple10410203supple_
suppled1248463suppled
suppler1148433suppler
supplest1248943supplest
supplies1268833supplies
swiples12339643swiples
swipples1534843swipples
tables84524893ta_bles
tackles133816523tackles
tadpoles1135953tadpoles
tailles72516473tailles
tales55451373ta__les
tamales93216153tamales
tangles83920043tangles
tapalos938813tapalos
tapeless10218643tapeless
tapes75838603ta_p_es
tapholes1339623tapholes
tapises92914013tapises
tapped113820053tapp_ed
tapper104419613tapp_er
tappers113416543tappers
tappet103820113tapp_et
tappets113610013tappets
tattles73616283tattles
taupes8212673taup_es
tawpies12309873tawpies
temples112610893temples
tipple103411913tipple_
tippled12358393tippled
tippler11348343tippler
tipplers12336353tipplers
topple104411323topple_
toppled12348843toppled
tramples122610203tramples
triples94616873triples
unpiles92112783unpiles
uppiles11208263uppiles
vales85434263va__les
wabbles144013993wabbles
waddles124314843waddles
waffles16329983waffles
waggles123812003waggles
wales86142833wa__les
wambles143714023wambles
wangles113416933wangles
wapped144416473wapp_ed
warbles123215563warbles
warsles103413643warsles
wattles103814073wattles
wimples143311173wimples
yapped144415143yapp_ed
yapper133714513yapp_er
yappers144012253yappers
yippies14279293yippies
yuppies14339263yuppies
zapped204213523zapp_ed
zapper193414023zapp_er
zappers203911633zappers
zappier20458373zappier
zappiest21228023zappiest
zeppoles2143583zeppoles

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.423422437.4
2DLD Change Limit1340274616.12321889.1
3Display Results4614610.1732664.7
 (SQL Overall)1786914616.71926594.9
 
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.