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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
compatibility245397(None) 
comparability2454902comparability
computability2455152computability
incompatibility2662622incompatibility
combustibility2562323combustibility
compatibilities2363623compatibilities
compatibly21134883compatib_l__y
capability1947594c_apa__bility
coilability1847934coila__bility
collapsibility2361964collapsibility
compatible18125574compatib_l__e
compatibles19134144compatib_l_es
compensability2563534compensability
compressibility2672554compressibility
conductibility2462814conductibility
contemptibility2691934contemp_tibility
contractibility2462584contractibility
convertibility2463274convertibility
corrigibility2163314corrigibility
corruptibility2362384corruptibility
countability1956584co_untability
culpability2045294culpa__bility
impassibility2254674_impassibility
imputability2146384_imputability
incomparability2662924incomparability
partibility1847114___partibility
acceptability2454125accep_tability
adaptability2055225adap_tability
admissibility2183125admissibility
adoptability2054765adop_tability
amiability1748745_amia__bility
castability1848415c__astability
cleanability1955225c_leanability
coagulability2153325coagulability
codifiability2473625codifiability
collaterality1862565collaterality
combatively2354645combativel__y
comicality1946135com___icality
communicability2862515communicability
commutativity2561975commutativity
compactible2153655compactib_l__e
comparabilities2374375comparabilities
comparably2154395comparab_l__y
compatriot1655965compat_ri_ot_
compatriotic2062175compat_riotic
compatriots1753545compat_ri_ots
competitively2562815competitively
complicity2145695comp___licity
compulsivity2491825comp_ulsivity
computabilities2354545computabilities
connaturality1872475connaturality
credibility1955505c__redibility
creditability2155695creditability
crossability1956105crossa__bility
curability1747865c_ura__bility
cutability1747865c___utability
decomposability2771695decomposability
deductibility2253515deductibility
defeasibility2254205defeasibility
digestibility2053725digestibility
dilatability1845455_dilatability
drapability1986475drapa__bility
expansibility2763475_expansibility
feasibility1945955__feasibility
formability2146965forma__bility
immiscibility2463345immiscibility
immutability2155895_immutability
impalpability2454115_impalpability
impartiality1953045_imparti_ality
impassability2265265_impassability
implacability2454885_implacability
implausibility2362925_implausibility
impossibility2254225_impossibility
incompatibly2364115incompatib_l__y
infeasibility2155725infeasibility
insatiability1856495_insatiability
lovability18106935lo_va__bility
meltability1848685__meltability
miscibility2055465__miscibility
movability2077235mo_va__bility
mutability1748075__m_utability
notability1549705no___tability
openability1846935_o_penability
operability1848855_o_perability
opposability2154395_opposability
optimality1753355_o_p_timality
palatability1946385_palatability
palpability2046335palpa__bility
portability1849565po__rtability
possibility1855825po__ssibility
potability1749815___potability
promotability2254805prom_otability
repeatability2056245repeatability
reputability1946985_reputability
resistibility1864375resistibility
roadability1757205ro__adability
separability1946915_separability
sociability1847925socia__bility
solvability1946415solva__bility
sorbability1846375sorba__bility
spatiality1544405__spati_ality
summability2045455summa__bility
treatability1747435_treatability
volatility1644865vo_lat__ility
workability2345385worka__bility

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 Filter1786911247900.406440125.6
2DLD Change Limit1247901058.86014084.7
3Display Results1051050.0931129.0
 (SQL Overall)1786911059.35919093.0
 
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.