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

319 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
edibles104800(None) 
edible969351edible_
ediles74016981edi_les
aediles83413902aedi_les
audibles11215532audibles
bibles104617642_bibles
dibbles124013332_dibbles
edifies113012282edifies
edile64819492edi_le_
enables92813122enables
enisles72312602enisles
exiles134816402exi_les
foibles1238852foibles
pedicles1338682pedicles
vendibles15164582vendibles
ables75935543__ables
addible11236063addible_
addles84216603ad_dles
adobes94411533adob_es
aedile73716653aedi_le_
aisles64721143_aisles
alibies9313323alibies
alible8311973alible_
ambles105121863_ambles
arables91814973arables
audible10228243audible_
audibled12224093audibled
audiles83112613audi_les
babbles104416323babbles
baubles113611863baubles
bedabbles1343043bedabbles
bedimples1642973bedimples
bible95119423_bible_
bibless11439173_bibless
biles75542143_bi_les
birles84920643_birles
bobbles104514913bobbles
bribees11409283bribees
bribes105918533brib_es
bridles104114473bridles
bubbles104315963bubbles
bumbles134016843bumbles
burbles114916803burbles
cables104527553_cables
cedillas1145743cedillas
chicles143512503chicles
chiles115425303chi_les
cobbles133814823cobbles
cobles104622883_cobles
credible1346023credible_
dabbles124514773dabbles
dales66439743_d_ales
dalles74222063_dalles
debyes1238103_debyes
decibels1344523decibels
deciles104417723deciles
deckles143312803deckles
defiles114016843defiles
deices94119373dei_ces
deifies113317453deifies
deils65722863dei_l_s
deities82621923deities
deles65139253_d_eles
derbies103016053derbies
dholes104914793_dholes
dialed84716453_dialed
dialer74315433_dialer
dialers83614303_dialers
dials64925343_dial_s
dibbed124713473_dibbed
dibber114614713_dibber
dibbers124013173_dibbers
dibble114013843_dibble_
dibbled133510843_dibbled
dibbler124510283_dibbler
dibblers13377583_dibblers
dibs76233683_dib__s
dices86434243_di_ces
diddles103915073_diddles
didies84621833_didies
didoes85716963_didoes
dienes75719903_dienes
dies55653523_di__es
dieses75218693_dieses
dikes105831333_di_kes
dilled84122223_dilled
dillies84122163_dillies
dills65530973_di_lls
dimes85833043_di_mes
dimples122813213_dimples
dindles93817243_dindles
dines66449153_di_nes
dinges83825423_dinges
dingles93818323_dingles
diodes83915783_diodes
diols65521013_diol_s
diplex16408053_diplex
diploes101111493_diploes
dipoles101013753_dipoles
dirges84915103_dirges
dirled84514903_dirled
dirls64720503_dirl_s
disables11410903_disables
dishes104622653_dishes
dismes95617673_dismes
disses75225963_disses
dites66339153_di_tes
ditzes163212423_ditzes
dives95832403_di_ves
dobies94422093_dobies
doblas93812293_doblas
doles67843753_d_oles
doubles103113353doubles
dribbles13348393dribbles
driblet103712243driblet
driblets11266093driblets
eagles73819163e_agles
eatables10169793eatables
eddies83313163ed_dies
eddoes8199143ed_does
edgeless1034883edgeless
edges75718743ed__ges
edibleness1345293edibleness
edicts94911703edi_cts
edifices1454863edifices
edified12339713edified
edifier11309263edifier
edifiers12336673edifiers
editable11310423editable_
edited83913673edi_ted
editors839423editors
editress944933editress
edits65819033edi__ts
educables1443473educables
educes94011953ed_uces
educible1344433educible_
egises7312493egi_ses
elides74420693eli_des
elidible1164573elidible_
eligibles12113063eligibles
elites66027123eli_tes
emblem1237583e_mblem
emblems1335043e_mblems
emigres1037673emigres
empales112411433empales
enable83318483enable_
enabled102510633enabled
enabler9299363enabler
enablers10196913enablers
endites83717063endi_tes
endives113710693endi_ves
enisle63412093enisle_
enisled82510223enisled
ennobles1045113ennobles
ensiles72714833ensiles
entitles8710663entitles
epiblast1245173epiblast
epibolies1345123epibolies
epistles1047783epistles
erodible1145493erodible_
etoiles7411293etoiles
evadible1443973evadible_
eviler94811893evi_ler
evilest10310473evi_lest
eviller1056673eviller
evillest1146353evillest
evils84114263evi_l_s
evinces1237803evinces
evites94916473evi_tes
exciples1964773exciples
exhales1737143exhales
exile126117653exi_le_
exiled144712463exi_led
exiler134712183exi_ler
exilers14419733exi_lers
exines135715803exi_nes
exitless1534883exitless
fables114921673_fables
failles102914133failles
fencibles1644093fencibles
fetiales11319613fetiales
fibres114312123_fibres
fiddles123212603fiddles
files85441273_fi_les
filles94224523_filles
fimbles143510663fimbles
foible11410383foible_
fribbles15287713fribbles
fumbles143514413fumbles
gabbles124415413gabbles
gables94222333_gables
gambles124016203gambles
garbles104016923garbles
ghiblis1353343ghiblis
gibes84422523_gib_es
giblet93418893_giblet
giblets103210423_giblets
gobbles123512583gobbles
gribbles13307363gribbles
grilles83715023grilles
guiles73919283gui_les
heddles123311623hed_dles
hobbles143313783hobbles
humbles143215803humbles
icicles1135943icicles
idles66720123__idles
inedible1147473inedible_
isles54220563__isles
jibes145520323_jib_es
jubiles16289373jubiles
jumbles183013323jumbles
kibbes143811193_kibbes
kibbles153510253kibbles
kibes115521113_kib_es
kiblas1239323_kiblas
legible1035833legible_
libels85112693_libels
lisles63416283_lisles
mailes84329113mai_les
mandibles1445543mandibles
marbles114516653marbles
meddles113213253med_dles
medials103914733medial_s
mediates112814063mediates
middles113415303middles
miles74645073_mi_les
milles84526563_milles
mobiles112813123mobiles
mumbles133014433mumbles
nibbles114011693nibbles
nobbles114014523nobbles
nobles83319723_nobles
nombles113212343nombles
nonedibles1353673nonedibles
nubbles113412433nubbles
numbles113814273numbles
odyles10348563od_yles
orioles7412993orioles
pebbles1337573pebbles
peddles112913703ped_dles
pedicels1336253pedicels
pedicle1238973pedicle_
pedicled1436463pedicled
periblem1445513periblem
periblems1543483periblems
petioles10311643petioles
piddles114314273piddles
piles74742613_pi_les
quibbles2134223quibbles
rabbles113517973rabbles
radicles11249703radicles
rambles113118313rambles
reddles93315773red_dles
redialed10310793redialed
redials84416883redial_s
redoubles1244263redoubles
refiles104122423refi_les
reliables1145903reliables
rendible11128353rendible_
resiles74026543resi_les
retables101712673retables
reticles103912483reticles
retiles74426993reti_les
retitles83612593retitles
reviles104421353revi_les
ribes75530173_rib_es
ribless93410343_ribless
riblet84222443_riblet
riblets93412553_riblets
riddles93215023riddles
rifles94217703_rifles
riles55343643_ri_les
rilles64725503_rilles
risibles1035783risibles
robles85321693_robles
roubles93413513roubles
rubbles113715113rubbles
rubles83921703_rubles
rumbles114018393rumbles
sables85026693_sables
sedile73517233sedi_le_
seniles72618023seni_les
sensibles1145953sensibles
sidles74721153_sidles
smiles84522293smi_les
spiles84227913spi_les
stables93219073stables
stifles103013393stifles
stiles64328773sti_les
swiples12339643swiples
tables84524893_tables
tailles72516473tailles
thimbles1536023thimbles
tiles55542103_ti_les
titles63719923_titles
toiles63923513toi_les
trebles9311443trebles
tribes85119023trib_es
trifles103814823trifles
triples94616873triples
tuilles72411923tuilles
tumbles113816023tumbles
umbles103817493_umbles
unedible1146413unedible_
vehicles16204683vehicles
vendables15165153vendables
vendible14156473vendible_
verbiles1338923verbiles
vesicles13127073vesicles
vibes104719953_vib_es
voiles94616443voi_les
wabbles144013993wabbles
wambles143714023wambles
warbles123215563warbles
whiles124418013whi_les
widdles123514343widdles
wiles85437873_wi_les
wimbles143010853wimbles
wobbles143412433wobbles

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.406440125.6
2DLD Change Limit1340273196.59320328.7
3Display Results3193190.1262531.7
 (SQL Overall)1786913197.12525079.4
 
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.