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

444 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
dapple113885(None) 
apple94517671_apple
dappled1336391dappled
dapples1238991dapples
ample94720302_ample
appel94615892_appel
apples104315762_apples
applet105917432_applet
apply125111392_apply
dabble114515192dabble
daddle94214282daddle
daggle93711902daggle
dale55643982da__le
damply14337892damply
dandle84218092dandle
dangle84119302dangle
daphne12237012daphne
dapped124516762dapped
dapper114016632dapper
darkle113813942darkle
dartle73714832dartle
dawdle11399502dawdle
dazzle1536852dazzle
dimple113512792dimple
dipole91112852dipole
duple85315862d_uple
fipple13329062fipple
grapple12378002grapple
hopple132910482hopple
maple95521142ma_ple
nappe96114992napp_e
nappie104112262nappie
nipple103410372nipple
papule102212132papule
popple92710982popple
rappee103618672rappee
rappel104211952rappel
ripple103413912ripple
sample104215012sample
supple10410202supple
tipple103411912tipple
topple104411322topple
abele76323253_abele
able66340533_a_ble
addle74318353_addle
agile65122263_agile
aisle55223193_aisle
ale36572343_a__le
amble95924633_amble
amole75724593_amole
ampler104313303_ampler
amply125012913_amply
ampule10710613ampule
anele55628833_anele
angle64528873_angle
anile54634463_anile
ankle95220253_ankle
anole55330373_anole
apace94718383_apace
ape57251183_a_p_e
app76827603_app__
appal95315223_appal
appall10379743_appall
appals104812943_appals
appels104312793_appels
applets115710063_applets
applied1247483_applied
applier1137903_applier
applies11311213_applies
appose10411993_appose
apps86319693_app_s
appulse1134673_appulse
apse67725383_a_pse
aptly105111813_aptly
argle65421563_argle
axile126020513_axile
axle116424603_a_xle
azole145118033_azole
babble94017113babble
baffle14399873baffle
bale66353843ba__le
bangle94018953bangle
battle85217863battle
bauble103813213bauble
buppie12288733buppie
cable95329913ca_ble
cackle143416923cackle
cajole154011183cajole
candle94321483candle
cantle84522153cantle
capable13313363capable
cape87242783ca_p_e
capelet11517073capelet
caplet104226813ca_plet
capote10315733capote
capped134721853capped
capper124421983capper
capsule1137343capsule
carle74535703ca_rle
carpale113414353carpale
carpel105418473carpel
castle84918963castle
cattle85118903cattle
caudle93912913caudle
chappie16298653chappie
couple104415963couple
crappie13298983crappie
cripple13378583cripple
cupule103410723cupule
dabbled133712073dabbled
dabbler124012153dabbler
dabbles124514773dabbles
dace76934923da__ce
dacite91115883dacite
daddled113810743daddled
daddles104213803daddles
daftly1335443daftly
daggled11329463daggled
daggles103611913daggles
dahl87019223da_hl_
dahls95012283da_hls
daily95922333da_ily
dal47554953da__l_
dales66439743da__les
dalles74222063da_lles
dally95324743da_lly
dals57145123da__ls
damage10410773damage
dame77140313da__me
damp96228843damp__
damped124315583damped
dampen114310593dampen
damper114117753damper
damps105220413damp_s
damsel9148033damsel
dance85223133da_nce
dandled103313543dandled
dandler94414273dandler
dandles94218533dandles
dangled104013153dangled
dangler96912813dangler
dangles93618423dangles
dangly114212263dangly
dankly14419463dankly
dap66652453da_p__
daphnes13327683daphnes
dapperer1335763dapperer
dapperly1643003dapperly
dapping133714783dapping
dappling1436843dappling
daps77239163da_p_s
dapsone1038463dapsone
dare55848863da__re
dariole8711163dariole
darkie113714013darkie
darkled13378713darkled
darkles124011933darkles
darkly145411073darkly
darnel74312183darnel
dartled9409853dartled
dartles84014133dartles
dassie74615573dassie
datable101714233datable
date56443323da__te
dative10311813dative
daube85015303da_ube
dautie72914693dautie
dawdled13376723dawdled
dawdler12356793dawdler
dawdles12379163dawdles
dawtie103011093dawtie
dayfly1633813dayfly
daze147327233da__ze
dazzled1735033dazzled
dazzler1634713dazzler
dazzles1636413dazzles
decile94619213decile
deckle1312012453deckle
decuple1285363decuple
deeply1257013deeply
defile105216663defile
dele56843083d__ele
depeople1344343depeople
depone93616553depone
depose94215763depose
depute94512303depute
dhole95215363d_hole
diazole1736793diazole
dibble114013843dibble
diddle94915213diddle
dimpled132810303dimpled
dimples122813213dimples
dimply14339743dimply
dindle84417223dindle
dingle84317073dingle
diplex16408053d_iplex
diploe9810153diploe
dipoles101013753dipoles
dippable1536123dippable
dipped123517493dipped
dipper114017783dipper
dippier123111393dippier
dippy135111543dipp_y
dispel9310323dispel
doable93115243doable
docile94213123docile
dole56550003d__ole
dongle83612493dongle
doodle83212853doodle
dope76038893d_op_e
dopily123510463dopily
dottle74212503dottle
double94013993double
drabble12238883drabble
draggle1056103draggle
drapable1377573drapable
drape85319633drap_e
droplet10312113droplet
drupe85012993drup_e
duffle13368533duffle
dupable12238383dupable
dupe76630603d_up_e
duplex16386973d_uplex
dupped124411643dupped
dyable12308983dyable
eagle64219483ea_gle
empale102611263empale
example1844283example
fable105824753fa_ble
facile112514883facile
faille93414743faille
farle86929243fa_rle
fipples14298653fipples
frappe13286953frapp_e
gabble113815723gabble
gable85325523ga_ble
gaggle93412623gaggle
gale56347323ga__le
gamble115417183gamble
gape75134513ga_p_e
gapped124217123gapped
gappier12369843gappier
gappy136212033gapp_y
garble94118453garble
gargle84215463gargle
grappled14336093grappled
grappler13336193grappler
grapples13348123grapples
gripple12416613gripple
habile11515203habile
hackle154916813hackle
haggle113511983haggle
hale76052833ha__le
handle104219293handle
hantle94318203hantle
haole84820083ha_ole
haply135915063ha_ply
happed144820103happed
happen134812193happen
happier143312033happier
happily1745763happily
happy155813533happ_y
hassle93711593hassle
hippie132811243hippie
hirple11158973hirple
hoppled15338083hoppled
hopples142810713hopples
impale102811653impale
jangle144416293jangle
jape134923423ja_p_e
kale86533753ka__le
kappa13469743kapp_a
kappas144410363kappas
koppie14277873koppie
labile8315213labile
ladle66320443la_dle
lapel73716683lapel_
lapeled10258893lapeled
lapels83712043lapels
lapped114320033lapped
lapper104319953lapper
lappet103817723lappet
lapse74917683la_pse
mackle143716433mackle
macle96127003ma_cle
macule104115273macule
magpie1139093magpie
maile75232213ma_ile
male66052293ma__le
mangle93921323mangle
maniple11249653maniple
mantle84420923mantle
maples104819423ma_ples
mappable1635923mappable
mapped134015883mapped
mapper124516093mapper
marble104219103marble
mayapple1741703mayapple
maypole1446383maypole
napalm1047263napalm
nape65230803na_p_e
nappa98511863napp_a
nappas105511613nappas
napped114218163napped
napper103718283napper
nappes104515623nappes
nappier114411173nappier
nappies114613393nappies
nappy126312333napp_y
nippled12307643nippled
nipples11319663nipples
paddle104615143paddle
padle84522343pa_dle
pale66055013__pale
papal95820673papal_
pappi84810893papp_i
pappier103511593pappier
pappies103214823pappies
pappose1047413pappose
pappus9408373pappus
pappy114713803papp_y
papula103011113papula
papulae11249353papulae
papules112411573papules
parle75836163pa_rle
parole84425253parole
pele65539553__pele
people10310183people
pile65649693__pile
pimple123512963pimple
pole65951303__pole
poppled11339233poppled
popples103011873popples
pule65040953__pule
purple102712673purple
rabble103818243rabble
rackle123917293rackle
raddle84816173raddle
raffle123910703raffle
raggle83712883raggle
rale45050563ra__le
ramble104519973ramble
rampole1139693rampole
rankle103414883rankle
rape65041633ra_p_e
raphae114311733raphae
raphe104916423ra_phe
rapine85023083rapine
rapped114122683rapped
rappees113611453rappees
rappeled1335003rappeled
rappels11448803rappels
rappen103512713rappen
rapper104621573rapper
raptly11338913raptly
rassle63813203rassle
rattle64717613rattle
reapply1434323reapply
rimple103814583rimple
rippled123110273rippled
rippler113210103rippler
ripples113513293ripples
ripplet113412583ripplet
ripply13348003ripply
rumple103913013rumple
sable74732163sa_ble
saddle83915493saddle
sale44959703sa__le
salpae84614273salpae
sampled123410783sampled
sampler113212013sampler
samples112815453samples
sapote8314353sapote
sapped114422013sapped
sapper103822353sapper
sappier113613113sappier
sappily1437163sappily
sappy125413473sapp_y
scrapple1434683scrapple
semple103212753semple
simple104315173simple
spale74929213_spale
spile75230083_spile
staple84415823staple
stipple1146623stipple
stopple1156583stopple
suppled1248463suppled
suppler1148433suppler
supples11511283supples
supply1346893supply
swiple11379233swiple
swipple1444633swipple
table75429603ta_ble
tackle123815733tackle
tadpole1036143tadpole
taille63116923taille
tale46154163ta__le
tamale83717393tamale
tangle74019953tangle
tapalo839793tapalo
tape64538143ta_p_e
taphole1239773taphole
tappable1436343tappable
tapped113820053tapped
tapper104419613tapper
tappet103820113tappet
tattle64115653tattle
taupe7314163taup_e
tawpie11339143tawpie
temple102811333temple
tippled12358393tippled
tippler11348343tippler
tipples112811253tipples
toppled12348843toppled
topples113111653topples
trample11299703trample
triple84215923triple
unpile81914323unpile
uppile10178503uppile
vagile10310543vagile
vale74937343va__le
wabble133714843wabble
waddle114715303waddle
waffle15369183waffle
waggle113612303waggle
wale74546433wa__le
wamble134415753wamble
wandle105316663wandle
wangle103817503wangle
wapped144416473wapped
warble113516603warble
warsle93112923warsle
wattle94314213wattle
wimple133611363wimple
yapped144415143yapped
yapper133714513yapper
yippee132810743yippee
yippie13277843yippie
yuppie13297133yuppie
zapped204213523zapped
zapper193414023zapper
zappier20458373zappier
zappy21548943zapp_y
zeppole2043493zeppole

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164445.93618988.5
3Display Results4444440.1403171.4
 (SQL Overall)1786914446.21628746.9
 
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.