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 “miserable” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
miserable134965(None) 
miserables1445611miserables
miserably1646661miserably
disenable1249672disenable
mineable121611052mine_able
missable12311532mis_sable
adherable1545003adherable
alterable1149163alterable
answerable1544153answerable
assurable1146013assurable
biteable1237933bite_able
citeable1238413cite_able
coverable1649103coverable
desirable1249393desirable
disable10516433dis__able
discernable1654453discernable
disenabled1444913disenabled
disenables1346233disenables
enterable11312643enterable
figurable1543733figurable
fileable13179223file_able
filterable1543723filterable
filtrable1484263filtrable
fineable131810333fine_able
fireable131710223fire_able
fishable1637593fis_hable
generable1238663generable
giveable14155753give_able
hirable121612313hi__rable
hireable13139083hire_able
inarable10313133_inarable
inerrable11410163_inerrable
inferable14411273inferable
insurable111011093insurable
isolable1038793_isolable
issuable1046873_issuable
kissable1436853kis_sable
lacerable1346943lacerable
lienable10188693li_enable
likeable14166473like_able
lineable101811083line_able
listable10810313lis_table
listenable1243653listenable
liveable13177663live_able
makeable1637253make_able
maskable1638003mas_kable
measurable1444723measurable
memorable1547533memorable
mensurable1445453mensurable
millable121710133mi_llable
minable112315073mi__nable
mineral9312733minera_l_
minerals10311373minera_ls
miracle1138843mi__racle
miscible1447673mis_cible
misease92713043mise_a_se
miserere1049273miser_ere
miserly12329823miser__ly
misframe1546973misfra_me
misgrade1247503misgra_de
mislabel1296173mis_label
misraise10410523mis_raise
misrate91319143mis_ra_te
misrule939353mis_r_ule
mistakable1843103mistakable
mistrace12312643mistra_ce
mistral91013643mistra_l_
mistrals101212623mistra_ls
mitigable1444753mitigable
mixable18259173mi__xable
moveable15168013move_able
numerable1347623numerable
observable1743343observable
operable12410323_operable
orderable1246183orderable
overable13513573_overable
pilferable1742873pilferable
raiseable1147243raise_able
referable1439623referable
reservable1546373reservable
reverable14310363reverable
rideable1158653ride_able
seeable91113943__seeable
servable13310093__servable
severable1438543severable
sewable121911173__sewable
sizeable1937113size_able
steerable1146913steerable
superable13312483superable
timetable1346873timetable
titrable1038963ti_trable
tolerable1147393tolerable
unseeable1149453unseeable
useable9911063_use_able
utterable1147153utterable
venerable1438483venerable
viewable1635223vi_ewable
visitable1445873visitable
wirable121610963wi__rable

Search took 7 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.436409841.7
2DLD Change Limit148641996.31323545.2
3Display Results99990.0462152.2
 (SQL Overall)178691996.79526297.4
 
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.