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

445 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
dappled133639(None) 
dapped124516761dapp_ed
dapple1138851dapple_
dapples1238991dapples
apple94517672_apple_
apples104315762_apples
applet105917432_applet
applied1247482_applied
capped134721852capp_ed
dabbled133712072dabbled
daddled113810742daddled
daggled11329462daggled
damped124315582damp_ed
dandled103313542dandled
dangled104013152dangled
dapper114016632dapp_er
darkled13378712darkled
dartled9409852dartled
dawdled13376722dawdled
dazzled1735032dazzled
dimpled132810302dimpled
dipped123517492dipp_ed
dupped124411642dupp_ed
gapped124217122gapp_ed
grappled14336092grappled
happed144820102happ_ed
hoppled15338082hoppled
lapeled10258892lapeled
lapped114320032lapp_ed
mapped134015882mapp_ed
napped114218162napp_ed
nippled12307642nippled
poppled11339232poppled
rapped114122682rapp_ed
rappeled1335002rappeled
rippled123110272rippled
sampled123410782sampled
sapped114422012sapp_ed
suppled1248462suppled
tapped113820052tapp_ed
tippled12358392tippled
toppled12348842toppled
wapped144416472wapp_ed
yapped144415142yapp_ed
zapped204213522zapp_ed
abled86926833_a_bled
adapted1135833adapted
addled94112513_addled
adopted1136253adopted
ailed66240283_a_iled
aisled74516183_aisled
ambled115116353_ambled
amped104820513_amp_ed
ample94720303_ample_
ampler104313303_ampler
aneled74719273_aneled
angled84219073_angled
ankled114313473_ankled
aped78538153_a_p_ed
appalled1344803_appalled
appealed1335593_appealed
appel94615893_app_el
appels104312793_appels
append1138273_append
applaud1293903_applaud
applets115710063_applets
applier1137903_applier
applies11311213_applies
apply125111393_appl_y
apposed1247853_apposed
argled85314543_argled
ariled75620323_ariled
axled135315813_a_xled
babbled113612863babbled
baffled16418063baffled
bailed94726653ba_iled
baled85436443ba__led
balled94926893ba_lled
battled104213123battled
bawled124415693ba_wled
bopped134413403bopp_ed
cabled114819873ca_bled
cackled164613293cackled
cajoled17428273cajoled
called94126733ca_lled
camped134720233camp_ed
canaled103615553canaled
candled113815733candled
caped104931803ca_p_ed
capelet11517073capelet
capered123014043capered
caplet104226813ca_plet
capper124421983capp_er
capsuled1334533capsuled
caroled103717683caroled
carped115923763carp_ed
castled104311513castled
caviled1348723caviled
chapped172711443chapp_ed
clapped143511173clapp_ed
copped135221253copp_ed
coupled124312673coupled
crapped143912623crapp_ed
crippled15336793crippled
cupeled1257793cupeled
cupped134413983cupp_ed
dabbed124416143da_bbed
dabble114515193dabble_
dabbler124012153dabbler
dabbles124514773dabbles
daddle94214283daddle_
daddles104213803daddles
dadoed9449893da_doed
daffed14429493da_ffed
daggle93711903daggle_
daggles103611913daggles
daisied93410013daisied
dale55643983da__le_
daledh1133743da__ledh
dales66439743da__les
dalles74222063da_lles
dallied93713603dallied
damaged1257453damaged
dammed124214793da_mmed
damned104212913da_mned
dampen114310593damp_en
dampened1435623dampened
damper114117753damp_er
damply14337893dampl_y
danced105315253da_nced
dandle84218093dandle_
dandler94414273dandler
dandles94218533dandles
danged94819483da_nged
dangle84119303dangle_
dangler96912813dangler
dangles93618423dangles
daphne12237013daphne_
daphnes13327683daphnes
dapperer1335763dapperer
dapping133714793dapping
dappling1436843dappling
dared75935013da__red
darked123919633da_rked
darkle113813943darkle_
darkles124011933darkles
darned85018483da_rned
darted84620923da_rted
dartle73714833dartle_
dartles84014133dartles
dashed115920563da_shed
dated75530993da__ted
daubed104611783da_ubed
daunted93810193daunted
dauted84114933da_uted
davened124610073davened
dawdle11399503dawdle_
dawdler12356793dawdler
dawdles12379163dawdles
dawed106222813da__wed
dawned113912093da_wned
dawted11489683da_wted
daybed13438673da_ybed
dazed165919363da__zed
dazzle1536853dazzle_
dazzler1634713dazzler
dazzles1636413dazzles
decupled1494983decupled
defiled124013103defiled
deled75326543d__eled
depeopled1543223depeopled
deponed113712873deponed
deposed113412023deposed
deputed114610173deputed
develed123611933develed
deviled124112183deviled
dialed84716453d_ialed
dialled9510133dialled
diapered1238003diapered
dibbled133510843dibbled
diddled114212053diddled
dilled84122223d_illed
dimple113512793dimple_
dimples122813213dimples
dindled104412723dindled
diplex16408053d_iplex
dipole91112853dipole_
dipoles101013753dipoles
dipper114017783dipp_er
dippier123111393dippier
dirled84514903d_irled
dogsled1035193dogsled
doiled84817293d_oiled
doled75430913d__oled
dolled83518073d_olled
doodled10369463doodled
doped95326713d_op_ed
doubled11289953doubled
doweled12269773doweled
drabbled14367053drabbled
draggled1254673draggled
draped105314363drap_ed
drawled12368343drawled
drilled94711673drilled
dripped13408083dripped
drolled93810223drolled
drooled9369203drooled
droplet10312113droplet
dropped13329283dropped
dueled84813663d_ueled
duelled9359753duelled
dulled84719423d_ulled
dumped123814493dump_ed
duped95118323d_up_ed
duple85315863d_uple_
duplex16386973d_uplex
dwelled12337593dwelled
eagled82914043ea_gled
easeled8159843easeled
empaled12288943empaled
exampled2043353exampled
fabled124216383fa_bled
failed105421603fa_iled
fipple13329063fipple_
fipples14298653fipples
flapped15328253flapp_ed
fopped144012673fopp_ed
frapped15318853frapp_ed
gabbled134112453gabbled
gabled105518453ga_bled
gaggled11359913gaggled
galled84622853ga_lled
gambled134112163gambled
gaoled84814493ga_oled
gaped96123533ga_p_ed
gappier12369843gappier
garbled114512803garbled
gargled104210673gargled
gasped104814293gasp_ed
gaveled12399133gaveled
gawped13509073gawp_ed
gipped124815903gipp_ed
grapple12378003grapple_
grappler13336193grappler
grapples13348123grapples
gypped15377113gypp_ed
hackled173312483hackled
haggled13359283haggled
hailed104122743ha_iled
haled95335823ha__led
handled124114533handled
happen134812193happ_en
happened1635653happened
happier143312033happier
harped124418403harp_ed
hasped125014443hasp_ed
hassled11358303hassled
hauled104415213ha_uled
hipped144317693hipp_ed
hirpled13157133hirpled
hopped144318113hopp_ed
hopple132910483hopple_
hopples142810713hopples
impaled12288503impaled
impled113812503_impled
jailed144917423ja_iled
jangled164111563jangled
japed156217633ja_p_ed
jauped16457903jaup_ed
kepped15309533kepp_ed
kipped153114573kipp_ed
knapped16397103knapp_ed
labeled102510563labeled
ladled85013483la_dled
lalled74218753la_lled
lamped114017543lamp_ed
lapelled11227083lapelled
lapper104319953lapp_er
lappered13288213lappered
lappet103817723lapp_et
lappeted13255833lappeted
lapsed94712583la_psed
lipped114419543lipp_ed
lopped114218623lopp_ed
mackled164111913mackled
macled116718113ma_cled
maculed123510053maculed
mailed95326753ma_iled
malled94626103ma_lled
mangled113615253mangled
mantled104113393mantled
maple95521143ma_ple_
maples104819423ma_ples
mapper124516093mapp_er
marbled123212113marbled
marled95523163ma_rled
mauled94817823ma_uled
mispled12310463mispled
mopped134114323mopp_ed
nailed74021493na_iled
naled65525053na__led
napalmed1342503napalmed
nappe96114993napp_e_
napper103718283napp_er
nappes104515623napp_es
nappie104112263nappie_
nappier114411173nappier
nappies114613393nappies
nipped113615853nipp_ed
nipple103410373nipple_
nipples11319663nipples
paddled123612023paddled
paled85538723__paled
palled94625163pa_lled
palped114513643palp_ed
paneled10612573paneled
papered122513163papered
pappier103511593pappier
pappies103214823pappies
papule102212133papule_
papules112411573papules
parled94626273pa_rled
paroled104217613paroled
peopled1238483peopled
pepped103113393pepp_ed
piled85232993__piled
pimpled14289183pimpled
pipped104516543pipp_ed
pled75231433___pled
poled84934843__poled
popped104117813popp_ed
poppied11388983poppied
popple92710983popple_
popples103011873popples
puled84926523__puled
pupped105013273pupp_ed
purpled12299753purpled
rabbled123514423rabbled
raddled103812223raddled
raffled14429083raffled
railed74727543ra_iled
ralphed1334363ralphed
rambled123913513rambled
ramped114617903ramp_ed
rankled123910653rankled
raped85334623ra_p_ed
rappee103618673rapp_ee
rappees113611453rappees
rappel104211953rapp_el
rappelled1443703rappelled
rappels11448803rappels
rappen103512713rapp_en
rapper104621573rapp_er
rasped94715203rasp_ed
rassled83310443rassled
rattled84012953rattled
raveled114113633raveled
reapplied1443673reapplied
repled93319773_repled
repped114616723repp_ed
rimpled123311423rimpled
ripped114419013ripp_ed
ripple103413913ripple_
rippler113210103rippler
ripples113513293ripples
ripplet113412583ripplet
rumpled123810013rumpled
saddled103112033saddled
sailed74327763sa_iled
sample104215013sample_
sampler113212013sampler
samples112815453samples
sapper103822353sapp_er
sappier113613113sappier
sepaled10510593sepaled
sipped113720633sipp_ed
slapped123511843slapp_ed
snapped124611203snapp_ed
sopped114819903sopp_ed
spalled103113123spalled
spiled94621993_spiled
stapled103613693stapled
stippled1345303stippled
stoppled1345003stoppled
supped114415703supp_ed
supple10410203supple_
suppler1148433suppler
supples11511283supples
supplied1345983supplied
swapped15429143swapp_ed
tabled94020043ta_bled
tackled143913183tackled
tailed74424663ta_iled
tamped114317043tamp_ed
tangled94214633tangled
taped85327423ta_p_ed
tapered102612933tapered
tapper104419613tapp_er
tappet103820113tapp_et
tattled84311483tattled
templed12278553templed
tipped114418263tipp_ed
tipple103411913tipple_
tippler11348343tippler
tipples112811253tipples
topped114617723topp_ed
topple104411323topple_
topples113111653topples
trampled13247903trampled
trapped124512213trapp_ed
tripled104113833tripled
tupped114013233tupp_ed
unapplied1443743unapplied
unpiled102312743unpiled
upped103715163_upp_ed
uppiled12216593uppiled
vailed104619293va_iled
vamped144211013vamp_ed
vapored1336923vapored
wabbled153311443wabbled
waddled133611643waddled
waffled17357523waffled
waggled13389363waggled
wailed104823593wa_iled
waled94330993wa__led
walled104021293wa_lled
wambled153610753wambled
wangled123312413wangled
warbled133212163warbled
warped124816413warp_ed
warsled112910443warsled
wattled113610503wattled
wauled104713963wa_uled
wawled133811703wa_wled
whapped18367573whapp_ed
wimpled15338823wimpled
wrapped15338023wrapp_ed
yapper133714513yapp_er
yauped12408333yaup_ed
yawled13459983ya_wled
yawped15528103yawp_ed
yipped143613283yipp_ed
zapper193414023zapp_er
zappier20458373zappier
zipped203612983zipp_ed

Search took 8 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 Limit1340274456.87319500.5
3Display Results4454450.1562852.6
 (SQL Overall)1786914457.18524870.0
 
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.