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

98 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
countability195658(None) 
accountability2362612accountability
cutability1747862c_u_tability
castability1848413c_astability
coilability1847933co_ilability
computability2455153computability
countabilities1856693countabilities
countably1646293countab_l__y
culpability2045293c_ulpability
curability1747863c_u_rability
equitability2645773equitability
mutability1748073_mu_tability
notability1549703no__tability
portability1849563po_rtability
potability1749813po__tability
printability1946863printability
quotability2555593_quotability
rentability16410193_rentability
suitability1647113_suitability
trustability1756133trustability
tunability1546983_tun_ability
acceptability2454124acceptability
actability1749084__actability
adaptability2055224adaptability
adjustability2652984adjustability
adoptability2054764adoptability
amenability1847494amen_ability
bankability2245244_bankability
brushability2253784brushability
capability1947594c__apability
changeability2453344changeability
cleanability1955224cleanability
coagulability2153324coagulability
codifiability2473624codifiability
combustibility2562324combustibility
communicability2862514communicability
comparability2454904comparability
compatibility2453974compatibility
compensability2563534compensability
conductibility2462814conductibility
connubiality1952384co_nnubiality
contractility2074074co_ntractility
corruptibility2362384corruptibility
countable1348854countab_l__e
creditability2155694creditability
crossability1956104crossability
cultivability2373684c_ultivability
deniability1748724_deniability
dilatability1845454dilatability
drinkability2254694drinkability
durability1647734_du_rability
educability1946244edu_cability
electability1947054electability
equability2446744equ__ability
excitability2655674excitability
forgeability2154574forgeability
formability2146964fo_rmability
fungibility2053884_fungibility
habitability2255094habitability
heritability2047984heritability
honorability2055814honorability
ignitability1856054ignitability
immutability2155894immutability
imputability2146384imputability
inability14411104__in_ability
instability1649444_instability
irritability1747484irritability
lovability18106934lo__vability
meltability1848684_meltability
modulability2064214modulability
movability2077234mo__vability
nonutility1355034nonut__ility
openability1846934_openability
operability1848854_operability
palatability1946384palatability
patentability2054784patentability
profitability2355134profitability
promotability2254804promotability
refundability2253944refundability
reputability1946984reputability
reusability1648474reu_sability
roadability1757204ro_adability
sociability1847924so_ciability
solvability1946414so_lvability
sorbability1846374so_rbability
stability14410084___stability
suability1448594_su__ability
summability2045454_summability
tenability1549124_ten_ability
testability1648804_testability
tolerability1776294tolerability
tractability1947094tractability
treatability1747434treatability
unsuitability1865134unsuitability
untenability1756424__untenability
usability1447164__u_sability
wettability1946484_wettability
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.403443402.0
2DLD Change Limit124790986.58018965.0
3Display Results98980.0631555.6
 (SQL Overall)178691987.04625360.6
 
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.