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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
parasexualities2472331parasexualities_
pansexualities2362933pa_nsexualities_
asexualities1994574___asexualities_
parasexuality25122604parasexualit___y
ambisexualities2682225ambisexualities_
antisexualities2263485antisexualities_
bisexualities22103635__bisexualities_
homosexualities2772295homosexualities_
paranormalities1981785paranormalities_
sexualities1857405____sexualities_
unisexualities2173205_unisexualities_
pansexuality2462706pa_nsexualit___y
parasexual1952966parasexual______
parfocalities2053716par__focalities_
partialities14108036par___tialities_
personalities1556476per_s_onalities_
practicalities2053566p_racticalities_
prequalifies2652796p_r__equalifies_
rascalities1347226__ras__calities_
actualities1346827___a_ctualities_
arabilities13413107_ara___bilities_
asexuality2053787___asexualit___y
avascularities19132187_avascularities_
axialities1747737___a__xialities_
cardinalities1654387car__dinalities_
carnalities1348787car____nalities_
casualties1244757__cas__ual_ties_
causalities1346227ca_us___alities_
classicalities1862537_classicalities_
coequalities2355567___coequalities_
credulities1444137_cr__edu_lities_
damageabilities2153367damageabilities_
desexualizes2954037__desexuali_zes_
drapeabilities1955997_drapeabilities_
equalities1949017_____equalities_
erasabilities1549637_eras_abilities_
factualities1754537__fa_ctualities_
farcicalities2053577far__cicalities_
garrulities1243517gar___ru_lities_
immaterialities1962877immaterialities_
inequalities2156147___inequalities_
irascibilities1854837_irascibilities_
irrationalities1563127irrationalities_
irrealities1146217_ir_re__alities_
manageabilities2053527manageabilities_
marginalities1654337mar__ginalities_
materialities1566397__materialities_
nasalities1048567__nas___alities_
palatabilities1846807pala_tabilities_
pansexuals1952087pa_nsexual____s_
parasites11313157paras_____it_es_
parasitise1277407paras_____iti_se
parasitised1474857paras_____itised
parasitises1377377paras_____itises
parasitism1466597paras_____iti_sm
parasitizes2266107paras_____itizes_
parasitologies1782367paras_itologies_
partibilities1748097par__tibilities_
particularities1993377particularities_
penalities121313477p____e_nalities_
perishabilities2255327perishabilities_
permeabilities2056847per_meabilities_
perpetuities1653477per_petu__ities_
perplexities2372627perplex___ities_
personalties1485157per_s_onal_ties_
perspicacities2261997per_spicacities_
phraseologies1953277phrase__ologies_
physicalities2393647p_hys_icalities_
predacities1646917p_r__e_dacities_
prehensilities1962177p_rehensilities_
prequalified2752047p_r__equalifie_d
primalities1548297p_r___imalities_
principalities2083207p_rincipalities_
prodigalities1763937p_r_odigalities_
punctualities1753467p__unctualities_
rationalities1357307__rationalities_
realities9316317__r__e__alities_
regalities11410597__r__e_galities_
requalifies2344357__r__equalifies_
seasonalities1353577_seas_onalities_
sedulities1147547____sedu_lities_
sensualities1265947____sensualities_
sequacities2244767____sequacities_
sexualizes2646537____sexuali_zes_
spiritualities1663697spir__itualities_
traceabilities1855877_traceabilities_
tranquilities2253907_tra_nquilities_
triaxialities2063047_tr_iaxialities_
unrealities1147537unr__e__alities_
virtualities1554697vir___tualities_
visualities1446557__vis__ualities_

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 Filter178691950240.343520965.0
2DLD Change Limit95024917.95311948.2
3Display Results91910.0631444.4
 (SQL Overall)178691918.35921377.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.