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

204 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
gainable113893(None) 
agitable1138582agitable
bailable1238582bailable
bannable1278352bannable
coinable12311582coinable
damnable1347592damnable
drainable1237582drainable
finable122213622_finable
guidable1236202guidable
jailable1737142jailable
joinable1737282joinable
laminable1337122laminable
linable92214342_linable
mailable1239622mailable
minable112315072_minable
paintable1337242paintable
pawnable1535982pawnable
raisable10311642raisable
ruinable1039262ruinable
sailable10310562sailable
stainable1138092stainable
tannable1039382tannable
trainable1138942trainable
actable11313473_actable
addable11218843_addable
affable15117403_affable
alienable1146933alienable
amenable1238863amenable
amiable11312033_amiable
amicable1438433amicable
arable81821003_a_rable
atonable1038793atonable
attainable1243743attainable
available1444903available
bankable1677913bankable
barnacle1245943barnacle
barrable1249253barrable
bindable13169623_bindable
bitable11312203_bitable
boilable1237793boilable
bribable1137223bribable
burnable1237263burnable
callable12310753callable
capable13313363ca_pable
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
castable121613973castable
causable1239973causable
citable11313463_citable
claimable1545703claimable
damnably1645113damnably
datable101714233da_table
dateable1149443dateable
definable1547773definable
deniable11312083deniable
disable10516433_disable
drinkable1644113drinkable
drivable1438023drivable
eatable91717603ea_table
editable11310423editable
enable83318483__enable
evitable1339323evitable
examinable2144093examinable
exilable1737203exilable
faceable15108493faceable
fadable13310463fa_dable
farmable1538203farmable
fatigable1544863fatigable
finagle11238313_finagle
finale94116763_fina_le
findable14179023_findable
fineable131810333_fineable
fixable19218193_fixable
foilable1338063foilable
friable122612563fri_able
gabble113815723ga__bble
gable85325523g___able
gainful1145833gainful_
gainly1049323gain__ly
galingale1143133galingale
gamble115417183ga__mble
ganache1346223ga_nache
garble94118453ga__rble
gaugeable1342983gaugeable
gelable101710733g_elable
getable101712553g_etable
gettable11178133gettable
giftable1465893giftable
giveable14155753giveable
gleanable1244083gleanable
gnawable1435683gnawable
grabbable1343193grabbable
gradable1238823gradable
grantable1257293grantable
graspable1444873graspable
grazable2036223grazable
grazeable2144153grazeable
gribble12297273gri_bble
growable1435623growable
gullable1136463gullable
gustable11138203gustable
habitable1645953habitable
hackable1937473hackable
hangable1438213hangable
hatable121713963ha_table
hateable1339373hateable
hidable1399403_hidable
hirable121612313_hirable
ignitable1245463ignitable
imaginable1544293imaginable
imitable1239123imitable
jammable2144513jammable
lapsable12117383lapsable
laudable1137893laudable
learnable1145563learnable
liable81415813_li_able
lienable10188693lienable
likable13219413_likable
lineable101811083_lineable
linkable14187263_linkable
livable122010323_livable
loanable1037613loanable
machinable1944263machinable
makable15510203ma_kable
makeable1637253makeable
manacle11310283ma_nacle
mappable1635923mappable
maskable1638003maskable
mineable121611053_mineable
mixable18259173_mixable
namable11312343na_mable
nameable1238863nameable
navigable1544743navigable
obtainable1443363obtainable
openable1247013openable
ownable1237283_ownable
oxidable1865123oxidable
packable1838633packable
palpable1448033palpable
parable111819783pa_rable
parsable12311693parsable
passable12310633passable
payable141711323pa_yable
pliable111610323pli_able
pointable1337343pointable
printable1338203printable
prunable1237843prunable
radiable11611303radiable
raiseable1147243raiseable
ratable91717553ra_table
rateable10311443rateable
refinable1438623refinable
ridable101412493_ridable
rinsable10310043_rinsable
salable91415463sa_lable
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiable10310733satiable
savable121711863sa_vable
saveable1339003saveable
sayable121411613sa_yable
scannable1345643scannable
seisable10311373seisable
seizable1938723seizable
singable11159543_singable
sinkable14178413_sinkable
sizable1839893_sizable
skiable1338883ski_able
slidable1137953slidable
stonable1039843stonable
suitable10310893suitable
takable13310193ta_kable
takeable1437463takeable
talkable1437193talkable
tamable11312853ta_mable
tameable1238603tameable
tapeable1238823tapeable
tappable1436343tappable
tastable101511973tastable
taxable1639073ta_xable
tenable93214493_tenable
thinkable1844063thinkable
triable92515393tri_able
tunable92511313_tunable
turnable1037853turnable
unable83819223__unable
valuable1336863valuable
variable13310063variable
viable111613773_vi_able
voidable1466853voidable
wadable13310233wa_dable
wadeable1437443wadeable
walkable1736063walkable
wannabe1234533wannab_e
wannabee1343993wannabee
washable16138043washable
wastable131410453wastable
waxable1937673wa_xable
windable14159153_windable
winnable13156983winnable
wirable121610963_wirable
writable1338753writable

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit1461622047.61019206.6
3Display Results2042040.0932193.5
 (SQL Overall)1786912048.10922036.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.