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

104 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
generable123866(None) 
venerable1438481venerable
enterable11312642_enterable
general81010932genera_l_
generally1347342generally
generals9109332genera_ls
generate9312902genera_te
penetrable1446042penetrable
referable1439622referable
regenerable1453882regenerable
renderable1397152renderable
renewable1447432renewable
reverable14310362reverable
severable1438542severable
tenurable1147422tenurable
venerables1544352venerables
venerably1746422venerably
adherable1545003adherable
alterable1149163alterable
bearable121512363be_arable
bendable131510853ben_dable
censurable1445653censurable
coverable1649103coverable
deferrable1644853deferrable
delegable13136643delegable
deletable12149503deletable
deniable11312083den_iable
denotable1238373denotable
denumerable1653133denumerable
desirable1249393desirable
deterrable1345723deterrable
enable83318483_en__able
endurable1247733_endurable
enumerable1444973_enumerable
enviable1337853_enviable
errable9312183_e_rrable
execrable2046233_execrable
exorable1738933_exorable
eyeable1239063_eye_able
feedable1437673fe_edable
fineable131810333fine_able
gelable101710733g__elable
genera71211713genera___
generalcy1543423generalcy
generalise11178123generalise
generalize20198453generalize
generated11310203generated
generates10312713generates
generative1458563generative
generator1067593generator
getable101712553g__etable
getatable1235953getatable
gettable11178133ge_ttable
giveable14155753give_able
gnawable1435683g_nawable
governable1643633governable
hearable131611603he_arable
honorable1446953honorable
ignorable1245333ignorable
inarable10313133_inarable
inerrable11410153inerrable
inferable14411263inferable
keepable1635323ke_epable
lacerable1346943lacerable
lendable11169463len_dable
lineable101811083line_able
memorable1547533memorable
mendable131510583men_dable
mensurable1445453mensurable
mineable121611053mine_able
miserable1349653miserable
nonarable1149053nonarable
numerable1347623numerable
operable12410323_operable
orderable1246183orderable
overable13513573_overable
peelable1238553pe_elable
ponderable1546083ponderable
preferable1746723preferable
reefable1339533re_efable
reelable10311593re_elable
relegable1258103relegable
renewables1543403renewables
renewably1744803renewably
rentable101716333ren_table
reparable1359953reparable
reservable1546363reservable
securable1347773securable
seeable91113943se_e_able
sendable111612043sen_dable
separable1348673separable
steerable1146913steerable
superable13312483superable
tearable101512673te_arable
temperable1645813temperable
tenable93214493ten__able
tolerable1147393tolerable
tuneable1038913tune_able
utterable1147153utterable
vegetable1545683vegetable
vendable14159693ven_dable
venerate11312903venera_te
vulnerable1542593vulnerable
wearable131510553we_arable

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411047.09320956.0
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.56223630.1
 
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.