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

101 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
trainabilities164661(None) 
attainabilities1753752attainabilities
stainabilities1655732stainabilities
traceabilities1855872traceabilities
tractabilities1846612tractabilities
availabilities1955753availabilities
drapabilities1847113dra_pabilities
drapeabilities1955993drapeabilities
drinkabilities2155063dr_inkabilities
drivabilities1947263dr_ivabilities
erasabilities1549633era_sabilities
friabilities1789173fr_i_abilities
germinabilities2084503germinabilities
inabilities13412753___inabilities
irritabilities1647323irritabilities
mailabilities1767713_mailabilities
obtainabilities1963403obtainabilities
pregnabilities1956563pregnabilities
printabilities1847323pr_intabilities
tenabilities14911493t__enabilities
trainability1746843trainabilit__y
tranquilities2253903tra_nquilities
treatabilities1657623treatabilities
trustabilities16105853trustabilities
tunabilities14138743t__unabilities
variabilities1848643vari_abilities
actabilities1649994__actabilities
adaptabilities1955634adaptabilities
admirabilities1956054admirabilities
advisabilities2055574advisabilities
affabilities2046944__affabilities
alienabilities1656224alienabilities
amenabilities1778844_amenabilities
amiabilities16109894__amiabilities
amicabilities19197914_amicabilities
arabilities13413104__a_rabilities
assignabilities1853084assignabilities
bankabilities2145914_bankabilities
bearabilities1748674bea_rabilities
breathabilities2254014breathabilities
brushabilities2154004brushabilities
capabilities1848824_ca_pabilities
castabilities1748834_castabilities
cleanabilities1856054cleanabilities
coilabilities1748094_coilabilities
creditabilities2065294creditabilities
crossabilities1855724crossabilities
decidabilities2046244decidabilities
deniabilities1649784deni_abilities
desirabilities1747534desirabilities
detonabilities1756704detonabilities
disabilities15411144__disabilities
drillabilities1754804drillabilities
driveabilities2055184driveabilities
equitabilities2566044equitabilities
excitabilities2556334excitabilities
fatigabilities2065384fatigabilities
flammabilities2363944flammabilities
formidabilities2353374formidabilities
frangibilities2054034frangibilities
habitabilities21125334habitabilities
heritabilities1958214heritabilities
ignitabilities17106334ignitabilities
inviabilities1848824invi_abilities
irascibilities1854834irascibilities
leachabilities2155544leachabilities
liabilities13710264__li_abilities
likabilities1877284__likabilities
livabilities1767724__livabilities
machinabilities2473084machinabilities
navigabilities2064964navigabilities
openabilities1748624_openabilities
packabilities2346574_packabilities
palpabilities1947254_palpabilities
placabilities1947634pla_cabilities
playabilities2046614pla_yabilities
pliabilities1649404_pli_abilities
probabilities1958094pr_obabilities
profitabilities2284584profitabilities
readabilities1649314_readabilities
reasonabilities1754664reasonabilities
reliabilities15410464_reliabilities
rentabilities15411264_rentabilities
repairabilities1955364repairabilities
reusabilities1549284_reusabilities
risibilities1448644_r_isibilities
roadabilities1647804_roadabilities
salabilities1449614_sa_labilities
shareabilities1955214shareabilities
sociabilities1748404soci_abilities
suitabilities1548104_suitabilities
survivabilities2352714survivabilities
tangibilities1655484t_angibilities
testabilities1549964t_estabilities
tolerabilities16116604tolerabilities
tranquillities2362464tra_nquillities
triaxialities2063044tr_i_axialities
untenabilities1657014untenabilities
viabilities1679684__vi_abilities
washabilities2146014_washabilities
wearabilities1848414wea_rabilities

Search took 4 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 Filter178691658740.1101624463.6
2DLD Change Limit658741013.48618896.7
3Display Results1011010.0601683.3
 (SQL Overall)1786911013.65648876.1
 
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.