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

124 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
desirabilities174752(None) 
decidabilities2046232decidabilities
deniabilities1649762deni_abilities
admirabilities1956023admirabilities
bearabilities1748673be_arabilities
desirability1847243desirabilit__y
deterrabilities1875383deterrabilities
detonabilities1756703detonabilities
disabilities15411093d__isabilities
drivabilities1947243d_rivabilities
durabilities1549333d__urabilities
heritabilities1958193heritabilities
insurabilities1676893insurabilities
measurabilities1964223measurabilities
memorabilities20137003memorabilities
mensurabilities1964413mensurabilities
reliabilities15410443reli_abilities
repairabilities1955363repairabilities
separabilities1847343separabilities
severabilities1947433severabilities
testabilities1549933tes_tabilities
venerabilities1967353venerabilities
wearabilities1848413we_arabilities
absorbabilities181675134absorbabilities
adorabilities1647804_adorabilities
advisabilities2055544advisabilities
alterabilities1667334alterabilities
amiabilities16109874_ami_abilities
amicabilities19197894_amicabilities
arabilities13413094___arabilities
assignabilities1853074assignabilities
assumabilities1853974assumabilities
availabilities1955744availabilities
believabilities22153944believabilities
castabilities1748794cas_tabilities
coilabilities1748074_coilabilities
creditabilities2065274creditabilities
curabilities1649384__curabilities
debilities13411294de____bilities
delectabilities2065554delectabilities
dependabilities2155244dependabilities
desirables1344214desirab_l___es
destabilizes2464054des_tabili_zes
detachabilities2354144detachabilities
detectabilities2065824detectabilities
dilatabilities1795934dilatabilities
disposabilities2053534disposabilities
divisibilities2064054divisibilities
drapabilities1847104d_rapabilities
drapeabilities1955984drapeabilities
drillabilities1754784drillabilities
drinkabilities2155034drinkabilities
driveabilities2055164driveabilities
dyeabilities1847864d__yeabilities
edibilities1458704_edi__bilities
educabilities1857064_educabilities
eligibilities1655644_eligibilities
equabilities2348154_e_quabilities
equitabilities2566014equitabilities
erasabilities1549604_erasabilities
excitabilities2556314excitabilities
fatigabilities2065374fatigabilities
feasibilities1866564feasi__bilities
fishabilities2146274fis_habilities
friabilities1789154_fri_abilities
fusibilities1746224fusi__bilities
germinabilities2084504germinabilities
habitabilities21125314habitabilities
honorabilities1955944honorabilities
ignitabilities17106304ignitabilities
inabilities13412734___inabilities
inevitabilities2055644inevitabilities
inexorabilities2454674inexorabilities
instabilities1549844ins_tabilities
inviabilities1848814invi_abilities
irritabilities1647294irritabilities
leachabilities2155534leachabilities
legibilities1547474legi__bilities
liabilities13710254__li_abilities
likabilities1877274__likabilities
livabilities1767714__livabilities
mailabilities1767694_mailabilities
meltabilities1749864me_ltabilities
navigabilities2064954navigabilities
observabilities2293744observabilities
operabilities17510054_operabilities
penetrabilities1965324penetrabilities
perdurabilities2074434perdurabilities
perishabilities2255274perishabilities
permeabilities2056824permeabilities
pliabilities1649384_pli_abilities
preferabilities2254604preferabilities
readabilities1649304re_adabilities
reasonabilities1754664reasonabilities
reformabilities2264534reformabilities
removabilities2186314removabilities
renewabilities1956204renewabilities
rentabilities15411234re_ntabilities
replicabilities2155104replicabilities
reputabilities1847424reputabilities
resectabilities1956014resectabilities
resistibilities1753974resistibilities
reusabilities1549264re_usabilities
risibilities1448624risi__bilities
salabilities1449604__salabilities
sensibilities1557364sensi__bilities
sewabilities1748934__sewabilities
sociabilities1748384soci_abilities
sorbabilities1746994__sorbabilities
stabilities13511754__s_tabilities
stainabilities1655724stainabilities
suabilities13610784__s_uabilities
suitabilities1548064_suitabilities
tenabilities14911484te__nabilities
tolerabilities16116604tolerabilities
trainabilities1646594trainabilities
unsuitabilities1754364unsuitabilities
usabilities1368984_us__abilities
variabilities1848634vari_abilities
verifiabilities2354434verifiabilities
viabilities1679674__vi_abilities
visibilities1747374visi__bilities
washabilities2145984was_habilities
wettabilities1847774we_ttabilities

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 Limit658741243.36019605.4
3Display Results1241240.0931333.3
 (SQL Overall)1786911243.56350151.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.