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

171 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
portability184955(None) 
potability1749801po_tability
exportability2774242exportability
formability2146952formability
notability1549692no_tability
partibility1847102partibility
probability2047692probability
sorbability1846362sorbability
workability2345372workability
actability1749073_actability
adoptability2054753adoptability
adorability1746893ador_ability
arability14411003_ar_ability
castability1848403castability
coilability1847923coilability
countability1956573countability
curability1747853cur_ability
cutability1747863_cutability
durability1647723dur_ability
forgeability2154563forgeability
friability1847883_friability
heritability2047973heritability
instability1649443instability
irritability1747473irritability
lovability18106923lo_vability
meltability1848683meltability
mortality1467733morta__lity
movability2077223mo_vability
mutability1748073_mutability
openability1846923openability
operability1848843operability
packability2446033packability
palatability1946373palatability
palpability2046323palpability
permeability2157163permeability
placability2047133placability
playability2146013playability
pliability1748043p_liability
portabilities17410203portabilities
portably1539313portab_l__y
possibility1855813possibility
printability1946853printability
profitability2355123profitability
promotability2254793promotability
quotability2555583quotability
rentability16410183rentability
roadability1757193roadability
sociability1847913sociability
solvability1946403solvability
stability14410083__stability
suitability1647113suitability
supportability2362233supportability
testability1648803testability
variability1947513variability
wettability1946483wettability
ability12311444____ability
absorbability1962884absorbability
adaptability2055214adaptability
affability2145674_affability
affordability2552644affordability
agreeability1855154agreeability
amenability1847484amenability
amiability1748734_amiability
amicability2047314amicability
bankability2245234bankability
bearability1847324bearability
biddability2043844biddability
capability1947584_capability
computability2455144computability
crossability1956094crossability
culpability2045294culpability
deniability1748724deniability
dilatability1845444dilatability
disability1649774_disability
drapability1986464drapability
drivability2046784drivability
dyeability1945884_dyeability
educability1946244educability
electability1947054electability
equability2446744_equability
equitability2645774equitability
erasability1668924erasability
erodibility1755954erodibility
excitability2655674excitability
fertility1547204fert__ility
fishability2245284fishability
formality1746984forma__lity
formidability2463984formidability
fragility1645554_fr_agility
gracility1546194_gr_acility
habitability2255094habitability
honorability2055804honorability
hostility1546374host__ility
ignitability1856044ignitability
immutability2155894immutability
improbability2464394improbability
improvability2564584improvability
imputability2146384imputability
inability14411104__inability
inviability1978744inviability
lability13710834___lability
liability14128484__liability
likability1996124_likability
livability1886744_livability
liveability1945794liveability
mailability1847294mailability
marketability2454124marketability
memorability2146434memor_ability
mobility1548544mo___bility
modulability2064204modulability
morality131110334mor_a__lity
morbidity1744144mor__bidity
motility1338734mo_t__ility
nobility1348984no___bility
normality1447194norma__lity
notabilia1153404no_tabili_a
opposability2154384opposability
orality101111684_or_a__lity
organicity1654154_organicity
overstability21125364overstability
partiality1546784part_iality
patentability2054774patentability
penetrability2055204penetrability
perdurability2154674perdurability
performability2663024performability
perishability2365224perishability
polarizability3062494polarizability
portabella1452274portabel_la
portabellas1552104portabellas
portabello1452094portabel_lo
portabellos15101874portabellos
portable12313204portab_l__e
portables1337874portab_l_es
potabilities16411314po_tabilities
pregnability2056154pregnability
probabilism1963204probabilism
probabilist1764214probabilist
probabilists1872944probabilists
rabidity1446584__r_abidity
readability1748064readability
reformability2354634reformability
reliability1649454reliability
repeatability2056234repeatability
reputability1946974reputability
reusability1648464reusability
salability1548514_salability
separability1946904separ_ability
sewability1846854_sewability
shareability2054914shareability
solubility1545274so_lubility
sortably1338804sortab_l__y
suability1448594__suability
summability2045444summability
tenability1549124_tenability
tolerability1776284tolerability
totality1139374to_ta__lity
tractability1947084tractability
treatability1747424treatability
trustability1756124trustability
tunability1546984_tunability
unworkability2552894unworkability
upgradability2253034upgradability
usability1447164__usability
versatility1755134versatility
viability1767874__viability
violability1946264violability
volatility1644864vo_latility
volubility1844414vo_lubility
vorticity1746144vort__icity
washability2245314washability
wearability1947094wearability

Search took 10 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 Filter1786911488190.1561145455.1
2DLD Change Limit1488191719.42315793.2
3Display Results1711710.0931838.7
 (SQL Overall)1786911719.67218475.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.