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

116 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
keepable163532(None) 
feedable1437672feedable
helpable1536602helpable
peelable1238552peelable
reapable12311392reapable
reefable1339532reefable
reelable10311592reelable
seeable91113942see_able
amenable1238863amenable
bearable121512363bearable
beatable121612243beatable
beddable14166923beddable
bendable131510853bendable
capable13313363_capable
chewable1835443chewable
culpable1436283culpable
delegable13136643delegable
deletable12149503deletable
deniable11312083deniable
dippable1536123dippable
drapable1377573drapable
dupable12238383_dupable
dyeable1337303dye_able
eatable91717603_eatable
effable15106673_effable
empale102611263_empa_le
enable83318483__enable
equable1849253_equable
errable9312183_errable
expiable1946113_expiable
eyeable1239063_eyeable
feeble1138253fee__ble
fellable13179133fellable
freezable2345093freezable
gelable101710733_gelable
generable1238663generable
getable101712553_getable
gettable11178133gettable
healable131610173healable
hearable131611603hearable
heatable131612043heatable
hewable15177823_hewable
jumpable2143953jumpable
keelage1236183keela_ge
keelhale1563023keelhale
keepsake1342233keepsake
keypal1534893keypa_l_
keypals1634353keypa_ls
kickable1535583kickable
killable14168133killable
kissable1436853kissable
kleagle1242923kle_agle
kneadable1645673kneadable
knowable1745033knowable
leasable101510133leasable
lendable11169463lendable
leviable1337513leviable
lienable10188693lienable
mappable1635923mappable
meltable12310473meltable
mendable131510583mendable
nestable101613673nestable
nettable101610243nettable
obeyable1544113obeyable
openable1247013openable
operable12410323operable
overable13513573overable
palpable1448033palpable
peccable1648103peccable
peephole1545983peephole
pettable121710713pettable
readable11313163readable
referable1439623referable
relegable1258103relegable
reliable10313073reliable
renewable1447433renewable
rentable101716333rentable
restable101618433restable
retable91820403_retable
reusable10811273reusable
reverable14310363reverable
rippable1435383rippable
ropable111611333_ropable
sealable101512693sealable
seepage1037543seepa_ge
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendable111612043sendable
servable13310083servable
severable1438543severable
sewable121911173_sewable
shapable15197803shapable
shedable1437423shedable
skippable1952583skippable
steerable1146913steerable
stewable1337133stewable
tapeable1238823tapeable
tappable1436343tappable
tearable101512673tearable
teasable101511173teasable
tellable10169773tellable
temptable1545813temptable
tenable93214493_tenable
testable101412623testable
tippable1435263tippable
typable1435883_typable
typeable1535233typeable
useable9911063use_able
vegetable1545683vegetable
vendable14159693vendable
venerable1438483venerable
viewable1635223viewable
wearable131510553wearable
weldable1436863weldable
wettable13148043wettable

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.1561145455.1
2DLD Change Limit1461621168.75016704.2
3Display Results1161160.0462521.7
 (SQL Overall)1786911168.95219961.0
 
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.