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

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

76 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
honorability205581(None) 
adorability1746903_adorability
honorabilities1955953honorabilities
honorably1745163honorab_l__y
honorarily1653063honoraril__y
memorability2146443memorability
notability1549703__notability
operability1848853_operability
tolerability1776293tolerability
venerability2046773venerability
absorbability1962894absorbability
admirability2055714admirability
affordability2552654affordability
alterability1747124alterability
arability14411014___arability
bankability2245244ban_kability
bearability1847334_bearability
changeability2453344changeability
coilability1847934co_ilability
comparability2454904comparability
confirmability2662594confirmability
contractility2074074contractility
countability1956584countability
curability1747864__curability
deniability1748734den_iability
desirability1847274desirability
detonability1856144detonability
durability1647744__durability
exportability2774254exportability
forgeability2154574forgeability
formability2146964fo_rmability
habitability2255094habitability
hatchability2553774hatchability
heritability2047984heritability
honorable1446954honorab_l__e
ignitability1856054ignitability
ignobility1654154igno__bility
immovability2454844immovability
inability14411114_in__ability
inexorability2585464inexorability
instability1649444_instability
insurability1757224insurability
inviability1978744_inviability
lovability18106934__lovability
mensurability2054384mensurability
modulability2064214modulability
movability2077234__movability
nobility1348984__no__bility
openability1846934_openability
opposability2154394opposability
penetrability2055214penetrability
portability1849564po_rtability
potability1749814__potability
probability2047704_probability
promotability2254804promotability
quotability2555594_quotability
reformability2354644reformability
removability2255734removability
renewability2055834renewability
rentability16410194ren_tability
roadability1757204ro_adability
separability1946914separability
severability2046754severability
sinterability1855214sinterability
sociability1847924so_ciability
solderability1963384solderability
solvability1946414so_lvability
sorbability1846374so_rbability
tenability1549124ten__ability
tunability1546984tun__ability
unknowability2572344unknowability
unworkability2552904unworkability
violability1946284_violability
vulnerability2153264vulnerability
wearability1947104_wearability
workability2345384wo_rkability

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 Filter1786911247900.390458182.1
2DLD Change Limit124790766.67318700.7
3Display Results76760.0461652.2
 (SQL Overall)178691767.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.