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

416 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
dyable1230898(None) 
doable93115241doable
dryable13237431dryable
dyeable1337301dyeable
able66340532__able
addable11218842addable
arable81821002arable
buyable1437492buyable
cable95329912_cable
dabble114515192dabble
dale55643982d_a_le
datable101714232datable
dibble114013842dibble
disable10516432disable
double94013992double
dowable13189452dowable
drabble12238882drabble
drably123511612drably
dupable12238382dupable
durable102312722durable
enable83318482enable
eyeable1239062eyeable
fable105824752_fable
flyable15307122flyable
fryable15277462fryable
gable85325522_gable
liable81415812liable
payable141711322payable
sable74732162_sable
sayable121411612sayable
stable83921642stable
suable83920552suable
table75429602_table
typable1435882typable
unable83819222unable
usable84012552usable
viable111613772viable
abbe87627183__abbe
abele76323253__abele
abled86926833__abled
abler75624313__abler
ables75935543__ables
ably99725133__ably
abye97921003__abye
actable11313473actable
addible11236063addible
adorable1138773adorable
affable15117403affable
ale36572343__a_le
alible8311973alible
amble95924633_amble
amiable11312033amiable
arables91814973arables
axle116424603__axle
babble94017113babble
babe86835813_bab_e
babel95821693_babel
bale66353843_ba_le
bauble103813213bauble
beadle93314683beadle
beagle93612593beagle
beddable14166923beddable
bible95119413_bible
biddable14165673biddable
bitable11312203bitable
bobble94115143bobble
brabble10349973brabble
bramble133710033bramble
bubale104014623bubale
bubble94016593bubble
bumble124216893bumble
burble104617703burble
cabled114819873_cabled
cabler104519173_cabler
cables104527553_cables
cablet104429463_cablet
capable13313363capable
carle74535703_carle
citable11313463citable
cobble123615263cobble
coble94823173_coble
codable12311663codable
copyable1736623copyable
cradle93313163cradle
curable112414513curable
cycle1239523cy_cle
dab67455563d_ab__
dabbed124416143d_abbed
dabber114816963d_abber
dabbled133712073dabbled
dabbler124012153dabbler
dabbles124514773dabbles
dabs77139403d_ab_s
dace76934923d_a_ce
daddle94214283daddle
daggle93711903daggle
dahl87019223d_ahl_
dahls95012283d_ahls
daily95922333d_aily
dal47554953d_a_l_
dales66439743d_a_les
dalles74222063d_alles
dally95324743d_ally
dals57145123d_a_ls
dame77140313d_a_me
damnable1347593damnable
dance85223133d_ance
dandle84218093dandle
dangle84119303dangle
dapple1138853dapple
dare55848863d_a_re
darkle113813943darkle
dartle73714833dartle
date56443323d_a_te
dateable1149443dateable
daube85015303d_aube
dawdle11399503dawdle
daybed13438673daybed
dayfly1633813dayfly
daze147327233d_a_ze
dazzle1536853dazzle
deadly113811473deadly
deafly13389123deafly
deal56347413dea_l_
dealer74122143dea_ler
deals65435343dea_ls
dealt65234283dea_lt
dearie73319813dearie
dearly104615323dearly
deave95022333dea_ve
debacle1237443debacle
debase94014473debase
debate94419193debate
debye1138903d_ebye
decayable1745623decayable
decile94619213decile
deckle1312012453deckle
defile105216663defile
delayable1546063delayable
dele56843083d__ele
deniable11312083deniable
dhal86719283dha_l_
dhals95415443dha_ls
dhole95215363d_hole
diabase1037113diabase
diablery1443233diablery
diabolo1065483diabolo
dial55935063dia_l_
dialed84716453dia_led
dialer74315433dia_ler
dialled9510133dialled
diallel845683diallel
dialler848813dialler
dials64925343dia_ls
diazole1736793diazole
dibbled133510843dibbled
dibbler124510283dibbler
dibbles124013333dibbles
diddle94915213diddle
dimmable1536113dimmable
dimple113512793dimple
dindle84417223dindle
dingle84317073dingle
dipole91112853dipole
dippable1536123dippable
disabled1248713disabled
disabler1147913disabler
disables11410903disables
djebel1643453djebel
dobie84920323d_obie
dobla84913643d_obla
docile94213123docile
dole56550003d__ole
dongle83612493dongle
doobie94712683doobie
doodle83212853doodle
dottle74212503dottle
doubled11289953doubled
doubler103110083doubler
doubles103113353doubles
doublet103914033doublet
doubly12328963doubly
drab76226453drab__
drabbed13428723drabbed
drabber12438593drabber
drabbet12319573drabbet
drabbled14367053drabbled
drabbles13308523drabbles
drabs85119673drab_s
dragee84415603dragee
draggle1056103draggle
drail65020973drail_
drails74716953drails
drake104918303dra_ke
drapable1377573drapable
drape85319633dra_pe
drave95219273dra_ve
drawable1467113drawable
drawee104413823drawee
drawl95516013drawl_
drawled12368343drawled
drawler11338593drawler
drawls105511393drawls
drawly134910723drawly
dribble12368603dribble
driblet103712243driblet
drivable1438023drivable
drumble12337893drumble
dual55928173dua_l_
dually103210063dually
duals65620083dua_ls
duffle13368533duffle
dumbly14399603dumbly
duple85315863d_uple
durables11237013durables
durably13229053durably
dutiable1137373dutiable
dyad96415453dya__d
dyadic1336093dyadic
dyads10549973dya_ds
dybbuk1841753dybbuk
dye75334843dy___e
dyke126418183dy__ke
dyne85320933dy__ne
dynel9569853dynel_
dynels10536813dynels
dynode1135023dynode
eagle64219483_eagle
eatable91717603eatable
edible969353edible
editable11310423editable
educable1337083educable
effable15106673effable
enabled102510633enabled
enabler9299363enabler
enables92813123enables
equable1849253equable
errable9312183errable
fabled124216383_fabled
fabler116115813_fabler
fables114921673_fables
fadable13310463fadable
farle86929243_farle
feeble1138253feeble
fimble133611743fimble
finable122213623finable
fixable19218193fixable
foible11410383foible
friable122612563friable
fumble133214263fumble
gabble113815723gabble
gabled105518453_gabled
gables94222333_gables
gale56347323_ga_le
gamble115417183gamble
garble94118453garble
gelable101710733gelable
getable101712553getable
gobble113512983gobble
grabble12339643grabble
gybe105916243gy_b_e
habile11515203_habile
hale76052833_ha_le
haole84820083_haole
hatable121713963hatable
hewable15177823hewable
hidable1399403hidable
hirable121612313hirable
hobble133913433hobble
humble133615053humble
jumble174012653jumble
kale86533753_ka_le
kibble143910953kibble
label75019383_label
labile8315213_labile
ladle66320443_ladle
likable13219413likable
linable92214343linable
livable122010323livable
losable91910953losable
lovable12179553lovable
lyase85512413lya_se
mabe85733343_mab_e
macle96127003_macle
maile75232213_maile
makable15510203makable
male66052293_ma_le
maple95521143_maple
marble104219103marble
maybe12311123mayb_e
measle83513223measle
minable112315073minable
mixable18259173mixable
movable14189433movable
mumble123614343mumble
mutable11312303mutable
mycele1335853mycele
myrtle1135733myrtle
nabe66029493_nab_e
namable11312333namable
nibble103713283nibble
nimble103412933nimble
nobble103814313nobble
noble74420993_noble
notable92114903notable
nubble103813713nubble
nyala836823nya_la
obeyable1544113obeyable
odyle9349593ody__le
oracle84313293oracle
ownable1237283ownable
padle84522343_padle
pale66055013_pa_le
parable111819773parable
parle75836163_parle
payables15166483payables
payably17177093payably
pebble1238003pebble
playable15137923playable
pliable111610323pliable
pokable15209503pokable
posable112212783posable
potable112115363potable
quale143617853qua_le
rabble103818243rabble
radiable11611303radiable
rale45050563_ra_le
ramble104519973ramble
ratable91717553ratable
retable91820403retable
ridable101412493ridable
rideable1158653rideable
roble75223023_roble
ropable111611333ropable
rouble83913313rouble
rowable121510303rowable
rubble104315673rubble
ruble74521253_ruble
rulable9310533rulable
rumble103718813rumble
sabe66140573_sab_e
sables85026693_sables
sabre74821503_sabre
salable91415463salable
sale44959703_sa_le
savable121711863savable
scabble13168653scabble
scale74629143sca_le
seeable91113943seeable
sewable121911173sewable
shale85332833sha_le
shamble14149263shamble
sizable1839893sizable
skiable1338883skiable
slayable13157563slayable
sowable121610753sowable
spale74929213spa_le
stabile9312063stabile
stabled103514953stabled
stabler94014933stabler
stables93219073stables
stably113314123stably
stale55637103sta_le
staple84415823staple
suably112814533suably
swale85221593swa_le
swayable16135533swayable
syllable13177773syllable
tabla73318363_tabla
tabled94020043_tabled
tables84524883_tables
tablet84227643_tablet
takable13310193takable
tale46154163_ta_le
tamable11312843tamable
taxable1639073taxable
teazle15329553teazle
tenable93214493tenable
totable92313363totable
towable121910113towable
treble8311663treble
triable92515393triable
tumble103215643tumble
tunable92511313tunable
typeable1535233typeable
unbale83616403unbale
undoable1139053undoable
usably11288983usably
useable9911063useable
vale74937343_va_le
viably14199833viably
vocable14189673vocable
votable122111373votable
wabble133714843wabble
wadable13310233wadable
wadeable1437443wadeable
wale74546433_wa_le
wamble134415753wamble
warble113516603warble
waxable1937673waxable
whale115517433wha_le
wimble133211913wimble
wirable121610963wirable
wobble133212313wobble
wyle105519383wy__le
yabber136111833_yabber
yabbie13308653_yabbie
yabby15389743_yabby
yald86920603_ya_ld
yare75636943_ya_re
yauld95511183_yauld
yawl104918973_yawl_
yawled13459983_yawled
yawls114613603_yawls
yodle94515043_yodle
yule75725143_y_ule

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164166.64016975.3
3Display Results4164160.2801485.7
 (SQL Overall)1786914167.06025310.3
 
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.