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

121 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
reachable1612965(None) 
leachable16136441leachable
teachable16137601teachable
bleachable1943382bleachable
breathable1744142breathable
coachable1846302coachable
detachable1844612detachable
peaceable1548242peaceable
poachable1846242poachable
readable11313162rea_dable
reapable12311392rea_pable
rescuable1347582rescuable
searchable1744142searchable
teachably19135182teachably
unreachable1846092unreachable
actable11313473__actable
attachable1743193attachable
beachball1843463beachball
bearable121512363bea_rable
beatable121612243bea_table
breakable1746163brea_kable
cashable15159793_cashable
catchable1845713catchable
creatable1339563crea_table
crunchable1942513crunchable
decayable1745623decayable
detachably2153213detachably
eatable91717603_ea_table
enactable1338493enactable
erasable10511043era_sable
erectable131210093erectable
exactable2046433exactable
faceable15108493_faceable
hackable1937473_hackable
hatchable1944793hatchable
healable131610173hea_lable
hearable131611603hea_rable
heatable131612043hea_table
impeachable2253923impeachable
leachate1347443leacha_te
learnable1145563learnable
leasable101510133lea_sable
matchable1845463matchable
munchable1844943munchable
packable1838633_packable
patchable1845633patchable
peaceably1845583peaceably
peccable1648103pe_ccable
placable14169243plac_able
placeable1536913placeable
quenchable2642203quenchable
radiable11611303r_adiable
raisable10311643r_aisable
ratable91717553r_a_table
rateable10311443r_ateable
reactance1346353reactance
readably1438383rea_dably
realizable2145333realizable
reasonable1246273reasonable
recallable1445373recallable
recappable1843723recappable
rechange1458183re_change
recharge1476613re_charge
recyclable1943643recyclable
reefable1339533re_efable
reelable10311593re_elable
referable1439623referable
refinable1438623refinable
refusable1476683refusable
refutable1477863refutable
regulable1246513regulable
relatable11310053relatable
relaxable1836363relaxable
relegable1258103relegable
reliable10313073re_liable
relishable1544523relishable
relivable1438513relivable
remarkable1844083remarkable
removable1646923removable
renewable1447433renewable
rentable101716333re_ntable
repairable1445953repairable
reparable1359953reparable
repayable1666343repayable
replaceable1743223replaceable
reproachable2152613reproachable
reputable1379123reputable
resalable1138733resalable
rescale93215473resc_a_le
researchable1951863researchable
resectable1478123resectable
restable101618433re_stable
resumable1347553resumable
retable91820403re__table
retractable1545123retractable
reusable10811273re_usable
reverable14310363reverable
revisable1437993revisable
revivable1736863revivable
revocable1647003revocable
revokable1845293revokable
rewardable1643883rewardable
rockable1638013r_ockable
sealable101512693sea_lable
stackable1735993stackable
stretchable1852813stretchable
tearable101512673tea_rable
teasable101511173tea_sable
torchable1645533torchable
touchable1645023touchable
traceable1338323traceable
trackable1736743trackable
tractable1338513tractable
treatable1139323trea_table
unactable13310053unactable
unbreachable2153413unbreachable
unteachable1845743unteachable
washable16138043_washable
watchable1944773watchable
wearable131510553wea_rable
weighable1843143weighable

Search took 10 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.1561145455.1
2DLD Change Limit1486411219.26616041.5
3Display Results1211210.0462630.4
 (SQL Overall)1786911219.46818873.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.