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

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

108 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
trainability174685(None) 
attainability18103982attainability
stainability1755682stainability
traceability1956532traceability
tractability1947092tractability
availability2055493availability
drapability1986483dra_pability
drapeability2055913drapeability
drinkability2254703dr_inkability
drivability2046803dr_ivability
erasability1668933era_sability
friability1847893fr_i_ability
germinability2155063germinability
inability14411113___inability
irritability1747483irritability
mailability1847303_mailability
obtainability2053573obtainability
pregnability2056163pregnability
printability1946863pr_intability
tenability1549123t__enability
trafficability2762253trafficability
trainabilities1646613trainabilities
tranquility2353383tra_nquility
treatability1747433treatability
trustability1756133trustability
tunability1546983t__unability
variability1947523vari_ability
actability1749084__actability
adaptability2055224adaptability
admirability2055714admirability
advisability2155064advisability
affability2145694__affability
alienability1745694alienability
amenability1847494_amenability
amiability1748744__amiability
amicability2047324_amicability
arability14411014__a_rability
assignability1962874assignability
bankability2245244_bankability
bearability1847334bea_rability
breathability2354084breathability
brushability2253784brushability
capability1947594_ca_pability
castability1848414_castability
cleanability1955224cleanability
coilability1847934_coilability
creditability2155694creditability
crossability1956104crossability
decidability2145744decidability
deniability1748734deni_ability
desirability1847274desirability
detonability1856144detonability
disability1649784__disability
drillability1854644drillability
driveability2155104driveability
equitability2645774equitability
excitability2655674excitability
extractability28103554extractability
fatigability2154994fatigability
flammability2453904flammability
formidability2463994formidability
frangibility2154024frangibility
habitability2255094habitability
heritability2047984heritability
ignitability1856054ignitability
inalienability1954554inalienability
intractability2155864intractability
inviability1978744invi_ability
irascibility1985414irascibility
leachability2255254leachability
liability14128494__li_ability
likability1996134__likability
livability1886754__livability
machinability2573914machinability
navigability2155444navigability
openability1846934_openability
packability2446044_packability
palpability2046334_palpability
placability2047144pla_cability
playability2146024pla_yability
pliability1748054_pli_ability
practicability2553324practicability
probability2047704pr_obability
profitability2355134profitability
readability1748074_readability
reasonability1854794reasonability
reliability1649464_reliability
rentability16410194_rentability
repairability2055854repairability
reusability1648474_reusability
risibility1547554_r_isibility
roadability1757204_roadability
salability1548524_sa_lability
shareability2054924shareability
sociability1847924soci_ability
suitability1647114_suitability
survivability2453184survivability
sustainability1962344sustainability
tangibility1754914t_angibility
testability1648804t_estability
tolerability1776294tolerability
trainable1138944trainab_l__e
tranquillity2462214tra_nquillity
triaxiality2162624tr_i_axiality
untenability1756424untenability
viability1767884__vi_ability
washability2245324_washability
wearability1947104wea_rability

Search took 9 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.390458182.1
2DLD Change Limit1247901087.54616537.2
3Display Results1081080.0631714.3
 (SQL Overall)1786911087.99922339.2
 
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.