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

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
traceability195653(None) 
tractability1947091tractability
drapeability2055912drapeability
trainability1746852trainability
actability1749083__actability
drapability1986473dra_pability
driveability2155093driveability
erasability1668933era_sability
extractability28103553extractability
intractability2155863intractability
leachability2255253leachability
packability2446043_packability
placability2047143plac_ability
shareability2054923shareability
traceabilities1855873traceabilities
traceably1646223traceab_l__y
treatability1747433treatability
trustability1756133trustability
adaptability2055224adaptability
affability2145684__affability
agreeability1855164agreeability
amenability1847494__amenability
amiability1748744__amiability
amicability2047324amic_ability
arability14411014__a_rability
attainability18103984attainability
availability2055494availability
bankability2245244_bankability
bearability1847334bea_rability
breathability2354084breathability
brushability2253784brushability
capability1947594_ca_pability
castability1848414_castability
changeability2453344changeability
crossability1956104crossability
damageability2253194damageability
detachability2454314detachability
drillability1854634drillability
drinkability2254694drinkability
drivability2046794dr_ivability
dyeability1945884__dyeability
educability1946244educ_ability
electability1947054electability
flammability2453904flammability
forgeability2154574forgeability
frangibility2154024frangibility
friability1847894fr__iability
gracility1546204grac___ility
hatchability2553774hatchability
incapability2156514incapability
irascibility1985414irascibility
irritability1747484irritability
liveability1945794_liveability
mailability1847304_mailability
malleability1954844malleability
manageability2153914manageability
marketability2454134marketability
palpability2046334_palpability
permeability2157174permeability
playability2146024pla_yability
practicability2553324practicability
preferability2355254preferability
pregnability2056164pregnability
printability1946864printability
probability2047704pr_obability
processability2363044processability
readability1748074_readability
reliability1649464_reliability
renewability2055834_renewability
rentability16410194_rentability
reusability1648474_reusability
roadability1757204_roadability
salability1548524_sa_lability
serviceability2462864serviceability
sociability1847924_sociability
stainability1755684stainability
stretchability2462134stretchability
tactility1446834t_ac__tility
tangibility1754914t_angibility
tenability1549124t__enability
testability1648804t_estability
tolerability1776294tolerability
traceable1338324traceab_l__e
tractabilities1846614tractabilities
tractably1646244tractab_l__y
trafficability2762254trafficability
tranquility2353384tra_nquility
transferability2361934transferability
tunability1546984t__unability
upgradeability2362434upgradeability
variability1947524_variability
washability2245324_washability
wearability1947104wea_rability

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.393454684.5
2DLD Change Limit124790936.96617914.2
3Display Results93930.0631476.2
 (SQL Overall)178691937.42224075.9
 
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.