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 “detectability” 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.

63 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
detectability215566(None) 
delectability2155671delectability
detachability2454312detachability
deterrability1974992deterrability
electability1947052_electability
resectability2056092resectability
affectability2663853affectability
deductibility2253513deductibility
dependability2254863dependability
detectabilities2065823detectabilities
detonability1856143det_onability
metastability2055573metastability
patentability2054783patentability
repeatability2056243repeatability
respectability2353973respectability
testability1648803__testability
wettability1946483wet__tability
acceptability2454124acceptability
actability1749084___actability
alterability1747124alte_rability
decidability2145744de_cidability
defeasibility2254204defeasibility
defensibility2254454defensibility
delectabilities2065564delectabilities
delectably18125684delectab_l__y
deniability1748724d__eniability
desirability1847274de_sirability
destructibility2372324destructibility
detectable15136604detectab_l__e
detestably16144394detestab_l__y
digestibility2053724digestibility
dilatability1845454d_ilatability
dyeability1945884d_ye__ability
educability1946244_educ_ability
equitability2645774_equitability
erectility1546264_erect__ility
excitability2655674_excitability
extendability2653594extendability
extractability28103554extractability
hatchability2553774hat_chability
heritability2047984he_ritability
impeccability2654464impeccability
indefectibility2673314indefectibility
ineluctability2185054ineluctability
integrability1956584integrability
intractability2155864intractability
leachability2255254le_achability
meltability1848684__meltability
penetrability2055214penetrability
perfectibility2663264perfectibility
predictability2454014predictability
presentability2164504presentability
preventability2464064preventability
remediability2154684remediability
renewability2055834rene_wability
rentability16410194__rentability
reputability1946984re_putability
severability2046754seve_rability
tenability1549124__te_nability
tractability1947094_tractability
treatability1747434_treatability
untenability1756424unte_nability
venerability2046774vene_rability

Search took 6 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 Limit95024634.59620675.4
3Display Results63630.0302100.0
 (SQL Overall)178691634.98635838.5
 
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.