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

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

114 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
incompatibility2662621incompatibility_
compatibility2453973__compatibility_
incomparability2662923incomparability_
incompatibly2364114incompatib_l__y_
comparability2454905__comparability_
compatibilities2363625__compatibilities
computability2455155__computability_
incapability2156515inc_apa__bility_
incompatible2054505incompatib_l___e
incompatibles2162755incompatib_l__es
incorrigibility2372265incorrigibility_
indomitability2254835indom_itability_
combustibility2562326__combustibility_
compatibly21134886__compatib_l__y_
contemptibility2691936contemp_tibility_
decomposability2771696decomposability_
impassibility2254676i___mpassibility_
imputability2146386i___mputability_
inadmissibility2392396inadmissibility_
incomparably2354026incomparab_l__y_
incomputably2364466incomputab_l__y_
incredibility2154716inc__redibility_
indefeasibility2463186indefeasibility_
indefectibility2673316indefectibility_
indigestibility2262576indigestibility_
infeasibility2155726in__feasibility_
insatiability1856496in___satiability_
inseparability2154436in_separability_
insociability2056226insocia__bility_
acceptability2454127_accep_tability_
accountability2362617acco_untability_
adoptability2054767_ado_p_tability_
biocompatible2381067biocompatib_l___e
capability1947597__c_apa__bility_
coilability1847937__coila__bility_
collapsibility2361967__collapsibility_
comparabilities2374377__comparabilities
compatible18125577__compatib_l___e
compatibles19134147__compatib_l__es
compensability2563537__compensability_
compressibility2672557__compressibility_
computabilities2354547__computabilities
conductibility2462817__conductibility_
contractibility2462587__contractibility_
convertibility2463277__convertibility_
corrigibility2163317__corrigibility_
corruptibility2362387__corruptibility_
countability1956587__co_untability_
culpability2045297__culpa__bility_
illimitability2162897illim_itability_
immiscibility2463347i__mmiscibility_
immovability2454847immo_va__bility_
immutability2155897i___mmutability_
impalpability2454117i___mpalpability_
impartiality1953047i___mparti_ality_
impassability2265267i___mpassability_
implacability2454887i___mplacability_
implausibility2362927i___mplausibility_
impossibility2254227i___mpossibility_
inability14411117in____a__bility_
inaccessibility2482487inaccessibility_
inaudibility1855307in___audibility_
incalculability2462217incalculability_
incapabilities2056217inc_apa__bilities
incivility1855197inc_____ivility_
incommutably2363787incommutab_l__y_
incomparable2054547incomparab_l___e
incompetently2263487incompetentl__y_
incomputable2075047incomputab_l___e
indefensibility2463237indefensibility_
indelibility1856247in___delibility_
indivisibility2373667in_divisibility_
indubitability2264077in_dubitability_
inducibility2055527in___ducibility_
ineducability2155447ineduca__bility_
ineffability2356407in_effa__bility_
ineligibility1955207in__eligibility_
ineluctability2185057in_eluctability_
inevitability2156967in__evitability_
inexorability2585467inexora__bility_
infallibility2164307in__fallibility_
inflammability2663467inflamma__bility_
inflexibility2883937in__flexibility_
infrangibility2363637in_frangibility_
infusibility2055807in___fusibility_
inheritability2255607in_heritability_
inhospitality2162057inhosp__itality_
inscrutability2163837in_scrutability_
insensibility1875917in__sensibility_
insolubility1754097inso___lubility_
instability1649447in____stability_
insurability1757227in_sura__bility_
intangibility1954877in__tangibility_
integrability1956587integra__bility_
intelligibility2162957intelligibility_
intervisibility2363257intervisibility_
intolerability1964527into_lerability_
intractability2155867in_tractability_
invariability2155977in___variability_
inviability1978747in__via__bility_
invincibility2374297in__vincibility_
inviolability2155117inviola__bility_
invisibility2056037in___visibility_
irresistibility2062667irresistibility_
noncompatible2163407noncompatib_l___e
notability1549707_n_o___tability_
partibility1847117_____partibility_
perceptibility2562947percep_tibility_
promotability2254807_prom_otability_
susceptibility23132187suscep_tibility_
unacceptability2681947unaccep_tability_
unpalatability2163097un_palatability_
unsociability2054897unsocia__bility_
unworkability2552907unworka__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 Filter178691950240.360496363.9
2DLD Change Limit950241149.23310291.8
3Display Results1141140.0931225.8
 (SQL Overall)1786911149.68618448.4
 
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.