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

315 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
gelable10171073(None) 
getable101712551getable
enable83318482_enable
fellable13179132fellable
gable85325522g__able
gelate73421262gela_te
gettable11178132gettable
gullable1136462gullable
healable131610172healable
helpable1536602helpable
hewable15177822hewable
meltable12310472meltable
peelable1238552peelable
reelable10311592reelable
relabel938162relabel
reliable10313072reliable
retable91820402retable
rulable9310532rulable
salable91415462salable
sealable101512692sealable
seeable91113942seeable
sellable101711822sellable
sewable121911172sewable
tellable10169772tellable
tenable93214492tenable
weldable1436862weldable
able66340533___able
actable11313473actable
addable11218843addable
affable15117403affable
agitable1138583agitable
agreeable1244653agreeable
alible8311973_alible
alliable1038433alliable
amenable1238863amenable
amiable11312033amiable
arable81821003_arable
bailable1238583bailable
beadle93314683be_adle
beagle93612593be_agle
bearable121512363bearable
beatable121612243beatable
bedabble1243703bedabble
beddable14166923beddable
belabor1136293belabor
belle75827833bel__le
bendable131510853bendable
billable12179503billable
bitable11312203bitable
boilable1237793boilable
buyable1437493buyable
cable95329913__cable
callable12310753callable
capable13313363capable
cellule936523cellule
cenacle1139123cenacle
chewable1835443chewable
citable11313463citable
codable12311663codable
culpable1436283culpable
curable112414513curable
datable101714233datable
debacle1237443debacle
delaine8314793delaine
delate73827753dela_te
delayable1546063delayable
delegable13136643delegable
deletable12149503deletable
deniable11312083deniable
disable10516433disable
doable93115243_doable
dowable13189453dowable
dryable13237433dryable
dupable12238383dupable
durable102312723durable
dyable12308983_dyable
dyeable1337303dyeable
eagle64219483_e_agle
eatable91717603eatable
edible969353_edible
effable15106673effable
elapse857523_elapse
elate55335883_ela_te
enabled102510633_enabled
enabler9299363_enabler
enables92813123_enables
equable1849253equable
errable9312183errable
exilable1737203exilable
eyeable1239063eyeable
fable105824753__fable
fadable13310463fadable
feeble1138253fe_eble
feedable1437673feedable
felafel1333723felafel
female11310553fema_le
fenagle11197153fenagle
fileable13179223fileable
fillable13179573fillable
filmable15157133filmable
finable122213623finable
fixable19218193fixable
flyable15307123flyable
foilable1338063foilable
foldable1437133foldable
friable122612563friable
fryable15277463fryable
furlable1335893furlable
gabble113815723g_abble
gabled105518453g__abled
gables94222333g__ables
gainable1138933gainable
galabia1038333galabia
galabieh1444823galabieh
gale56347323g__a_le
gamble115417183g_amble
garble94118453g_arble
gelada837623gela_da
geladas936313geladas
gelant72821673gela_nt
gelants82611443gelants
gelated93615643gelated
gelates83219593gelates
gelati73814533gela_ti
gelatin83514733gelatin
gelatine93213313gelatine
gelatis83313513gelatis
gelato73812963gela_to
gelatos83111523gelatos
gelee63626983gel__ee
gelidly1234753gelidly
gelled84718893gel__led
gemmule12173233gemmule
generable1238663generable
gentile83515293gentile
gentle74014513ge_ntle
getatable1235953getatable
giftable1465893giftable
giveable14155753giveable
glace87420163g_la_ce
glade75121963g_la_de
gladly11497933g_ladly
glaire74411303g_laire
glaive10357933g_laive
glance94312313g_lance
glare65222963g_la_re
glaze155418163g_la_ze
gleanable1244083gleanable
glebae9407613g_lebae
glebe85016443g_leb_e
glibly1236293g_libly
globe84917013g_lob_e
globule1034383g_lobule
gnawable1435683gnawable
gobble113512983g_obble
grabble12339643grabble
gradable1238823gradable
grazable2036223grazable
gribble12297273gribble
growable1435623growable
grumble12349233grumble
guessable1243733guessable
guidable1236203guidable
gullably1444793gullably
gullible1144063gullible
gustable11138203gustable
hatable121713963hatable
hearable131611603hearable
heatable131612043heatable
hidable1399403hidable
hirable121612313hirable
holdable1437073holdable
isolable1038793isolable
jailable1737143jailable
keepable1635323keepable
killable14168133killable
kleagle1242933kleagle
label75019383__label
labelable1344393labelable
labile8315223__labile
ladle66320443__ladle
leasable101510133leasable
legible1035833legible
lendable11169463lendable
leviable1337513leviable
liable81415813_liable
lienable10188693lienable
likable13219413likable
linable92214343linable
livable122010323livable
losable91910953losable
lovable12179553lovable
mailable1239623mailable
makable15510203makable
measle83513223me_asle
melange1038363melange
mendable131510583mendable
millable121710133millable
minable112315073minable
mixable18259173mixable
moldable1337103moldable
movable14189433movable
mutable11312303mutable
namable11312343namable
nestable101613673nestable
nettable101610243nettable
notable92114903notable
obeyable1544113obeyable
openable1247013openable
operable12410323operable
overable13513573overable
ownable1237283ownable
palpable1448033palpable
parable111819773parable
payable141711323payable
pebble1238003pe_bble
peccable1648123peccable
pelage9515363pela_ge
pettable121710713pettable
pliable111610323pliable
pokable15209503pokable
posable112212783posable
potable112115363potable
quellable2043673quellable
ratable91717553ratable
readable11313163readable
reapable12311393reapable
reefable1339533reefable
regale74821453rega_le
regulable1246513regulable
relabeled1243923relabeled
relabels1045343relabels
relace83122153rela_ce
relapse947703relapse
relatable11310053relatable
relate64033633rela_te
relaxable1836363relaxable
relegable1258103relegable
reliables1145903reliables
reliably1339243reliably
relivable1438513relivable
rentable101716333rentable
resalable1138733resalable
resale64025543resa_le
restable101618443restable
retables101712673retables
reusable10811273reusable
ridable101412493ridable
ropable111611333ropable
rowable121510303rowable
sable74732163__sable
sailable10310563sailable
salably121610743salably
saleable10312023saleable
salvable1338403salvable
savable121711863savable
sayable121411613sayable
scalable121710233scalable
seisable10311373seisable
seizable1938723seizable
selle54428313sel__le
semblable1544843semblable
sendable111612043sendable
servable13310093servable
shedable1437423shedable
sizable1839893sizable
skiable1338883skiable
soluble966103soluble
solvable1337473solvable
sowable121610753sowable
stable83921643_stable
stealable1136573stealable
stewable1337133stewable
suable83920553_suable
syllable13177773syllable
table75429603__table
takable13310193takable
talkable1437193talkable
tamable11312853tamable
taxable1639073taxable
tearable101512673tearable
teasable101511173teasable
teazle15329553te_azle
telae54323293tela__e
tenably122210453tenably
testable101412623testable
tillable10159753tillable
tiltable10159013tiltable
totable92313363totable
towable121910113towable
triable92515393triable
tunable92511313tunable
typable1435883typable
unable83819223_unable
usable84012553_usable
useable9911063useable
valuable1336863valuable
vegetable1545683vegetable
velate93720143vela_te
vendable14159693vendable
viable111613773_viable
viewable1635223viewable
violable1337543violable
vocable14189673vocable
voluble1244503voluble
votable122111373votable
wadable13310233wadable
walkable1736063walkable
waxable1937673waxable
wearable131510553wearable
wettable13148043wettable
wieldable1543813wieldable
willable13168683willable
wirable121610963wirable
yieldable1543353yieldable

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.456391866.2
2DLD Change Limit1340273157.14018771.3
3Display Results3153150.1102863.6
 (SQL Overall)1786913157.70623188.6
 
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.