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

175 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
probable143905(None) 
probables1545421probables
probably1746411probably
provable1539091provable
bribable1137222bribable
erodable1139202erodable
growable1435622growable
improbable1844832improbable
parolable1347112parolable
plowable1535912plowable
pokable15209502p_okable
portable12313202portable
posable112212782p_osable
potable112115362p_otable
probate11414482proba_te
provably1846212provably
prunable1237842prunable
ropable111611332_ropable
rowable121510302_rowable
sorbable1239302sorbable
abrogable1444573abrogable
adorable1138773adorable
apposable1545603apposable
approvable1963933approvable
arable81821003ar__able
arguable1135903arguable
arousable1145573arousable
atonable1038793atonable
avowable1635453avowable
bobble94115143_bob_ble
bombable1336263bombable
bookable16127003bookable
bootable12179223bootable
brabble10349973brab_ble
browsable1643863browsable
closable12168003closable
clubable1436093clubable
cobble123615263_cob_ble
codable12311663_codable
cookable16147973cookable
crossable1347073crossable
curbable1447663curbable
doable93115243_do_able
dowable13189453_dowable
drabble12238883drab_ble
drapable1377573drapable
drawable1467113drawable
dribble12368603drib_ble
drivable1438023drivable
droppable1643273droppable
dryable13237433dr_yable
erasable10511043erasable
erodible1145493erodible
erosible1046443erosible
errable9312183er_rable
evocable1537103evocable
exorable1738933exorable
fordable1439593fordable
formable1539503formable
framable1537573framable
friable122612563fr_iable
fribble14287783frib_ble
fryable15277463fr_yable
gobble113512983_gob_ble
grabbable1343193grabbable
grabble12339643grab_ble
gradable1238823gradable
grazable2036223grazable
gribble12297273grib_ble
groupable1443643groupable
hobble133913433_hob_ble
improbably2153683improbably
improvable1945253improvable
isolable1038793isolable
knowable1745033knowable
losable91910953_losable
lovable12179553_lovable
movable14189433_movable
nobble103814313_nob_ble
notable92114903_notable
opposable1544063opposable
packable1838633packable
palpable1448033palpable
parable111819773p_arable
pardonable1544023pardonable
parsable12311693parsable
passable12310623passable
pawnable1535983pawnable
payable141711323p_ayable
pebble1238003p_eb_ble
peccable1648103peccable
peelable1238553peelable
permeable1556813permeable
personable1467073personable
perusable1347453perusable
pettable121710713pettable
pitiable1238293pitiable
pivotable1644563pivotable
placable14169243placable
playable15137923playable
pliable111610323p_liable
plumbable1743323plumbable
porbeagle1482253porbeagle
portables1337873portables
portably1539313portably
potables12179703p_otables
pourable1239133pourable
preamble1436373preamble
prebade12310283preba_de
prebake1539093preba_ke
prebattle1343013prebattle
pregnable1456693pregnable
presale9416353presa_le
previable1647533previable
priceable1546823priceable
printable1338203printable
proband122710243proba_nd
probands13228383probands
probang12278383proba_ng
probangs13256203probangs
probated13410863probated
probates12414263probates
probative1649173probative
probe94320813pro__b_e
problem1335983pro__blem
procaine12312273procaine
procurable1644863procurable
profane122111863profa_ne
profile123211153pro_file
profitable1744963profitable
prolabor1284533prolabor
prolapse12134913prolapse
prolate9419793prola_te
prole74527793pro___le
promotable1645033promotable
pronate9418873prona_te
propagable1743353propagable
propagule1443253propagule
propane112716153propa_ne
prorate9418733prora_te
prostyle13187273prostyle
protyle12229453pro_tyle
purgeable1444413purgeable
pursuable1344693pursuable
quotable1936493quotable
rabble103818243_rab_ble
ratable91717553_ratable
retable91820403_retable
ridable101412493_ridable
robalo838923_roba_lo
roble75223023_ro__ble
rockable1638013_rockable
rouble83913313_ro_uble
rubble104315673_rub_ble
rulable9310533_rulable
showable1636583showable
smokable1636223smokable
sortable10312483sortable
sowable121610753_sowable
stonable1039843stonable
storable10310733storable
stowable1337613stowable
totable92313363_totable
towable121910113_towable
tradable1139873tradable
triable92515393tr_iable
trouble957703tro_uble
tubbable1134683tubbable
unprovable1745713unprovable
violable1337543violable
vocable14189673_vocable
votable122111373_votable
wobble133212313_wob_ble
workable1737093workable
writable1338753writable

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 Filter1786911461620.1601116818.8
2DLD Change Limit1461621756.93621073.0
3Display Results1751750.1561121.8
 (SQL Overall)1786911757.25224640.2
 
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.