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

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

93 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
impermeability256391(None) 
permeability2157172__permeability
impeccability2654463impe_ccability
imperishability2772723imperishability
impregnability24163233impregnability
improbability2464403imp_robability
improvability2564593imp_rovability
hypermobility2863324hyperm_obility
hypermutability3072444hypermutability
impalpability2454114imp_alpability
impassability2265264imp_assability
impenetrability2462484impenetrability
impermeable1953974impermeab_l__e
implacability2454884imp_lacability
imponderability25132144imponderability
impressibility2364404impressibility
imputability2146384imp__utability
inheritability2255604inheritability
operability1848854_oper__ability
agreeability1855165__agreeability
alterability1747125alter__ability
amenability1847495am_e__nability
appealability2253965appe_alability
comparability2454905compar__ability
compensability2563535compe_nsability
dependability2254865depe_ndability
deterrability1974995deter_rability
dispensability2263205dispe_nsability
employability2553045emp_loyability
enforceability2472555enforceability
erasability1668935___erasability
expendability2853845expe_ndability
exportability2774255expor_tability
filterability2153705filter__ability
foreseeability2262395foreseeability
forgeability2154575__forgeability
formability2146965__form_ability
germinability2155065__germinability
heritability2047985__heritability
immobility1945355im___m_obility
immovability2454845im__movability
immutability2155895im__mutability
impartiality1953045impartia__lity
impassibility2254675imp_assibility
impersonality2063605imper_sonality
implausibility2362925implausibility
impossibility2254225imp_ossibility
indefinability2384795indefinability
ineducability2155445i_neducability
ineffability2356405i_ne_ffability
inevitability2156965i_nevitability
inexorability2585465i_nexorability
inflammability2663465inflammability
inscrutability2163835inscrutability
inseparability2154435inseparability
insurability1757225insur__ability
integrability1956585inte_grability
interfertility2063085interfertility
invariability2155975invar_iability
irreformability2562035irreform_ability
irrefragability2461955irrefragability
irrefutability2293405irrefutability
irremovability2462945irremovability
irrevocability2482945irrevocability
irritability1747485i__rritability
malleability1954845_m_alleability
manageability2153915_manageability
marketability2454135_m_arketability
meltability1848685_m_e_ltability
memorability2146445_m_emorability
observability2353495obser_vability
openability1846935_ope__nability
overstability21125375_overstability
perdurability2154685__perdurability
perishability2365235__perishability
permeabilities2056845__permeabilities
permeably1864895__permeab_l__y
portability1849565__por_tability
preferability2355255__preferability
pregnability2056165__pregnability
probability2047705__p_robability
reformability2354645reform_ability
repeatability2056245repe_atability
separability1946915separ__ability
severability2046755sever__ability
shareability2054925_shar_eability
sinterability1855215sinter__ability
spreadability2154405_spreadability
thermolability2462745_thermolability
tolerability1776295toler__ability
upgradability2253045_upgradability
upgradeability2362435_upgradeability
venerability2046775vener__ability

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 Filter178691950240.703254183.5
2DLD Change Limit95024938.54611119.1
3Display Results93930.0631476.2
 (SQL Overall)178691939.31219189.3
 
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.