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

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

107 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
atypicalities205268(None) 
typicalities1954151_typicalities
topicalities1655582_topicalities
atypicality2152123atypicalit__y
ethicalities1754443et_hicalities
physicalities2393643physicalities
animalities1348994a__nimalities
artificialities2061964artificialities
atomicities1545954atomic__ities
atonalities1148404at__onalities
atonicities1346684atonic__ities
axialities1747734a__xi_alities
comicalities1846974_comicalities
criticalities1754684criticalities
cyclicalities1953034cyclicalities
farcicalities2053574farcicalities
hospitalities1854124hospitalities
lexicalities2154724_lexicalities
logicalities1555054_logicalities
materialities1566394materi_alities
musicalities1655824_musicalities
spiralities1348014__spiralities
typicality2053244_typicalit__y
verticalities1885214verticalities
abilities11714145a__bi__lities
abnormalities1752575abnormalities
actabilities1649995actabi__lities
actualities1346825a__ctualities
admiralties1452095a_dmiral_ties
agilities10810975a__gi__lities
amicabilities19197915a__micabilities
amoralities1347425a__moralities
analities9715875a____nalities
anilities9516005a__ni__lities
applicabilities2353745applicabilities
arabilities13413105arabi__lities
asexualities1994575a_sexualities
atrocities1248595at_roc__ities
attainabilities1753755attainabilities
atypical1544685atypical_____
atypically2045745atypical___ly
audibilities1546645a_udibilities
auralities10410225a___uralities
auspicates1444915auspica__t_es
bestialities1455495besti_alities
bipedalities17123645_bipedalities
cardinalities1654385cardinalities
chiralities1646515__chiralities
classicalities1862535classicalities
cordialities1546155cordi_alities
corporalities1755295corporalities
criminalities1754745criminalities
efficacities2252195_efficacities
etherealities1653695etherealities
ethnicities1655445ethnic__ities
fatalities1349445fat____alities
finalities1349905___finalities
genialities12148645_geni_alities
illogicalities17132525illogicalities
jovialities2145165_jovi_alities
labialities1347035_labi_alities
localities1259735___localities
marginalities1654335marginalities
natalities10410665nat____alities
nationalities1356915nat_ionalities
nuptialities1454785_nuptialities
optimalities1654665_optimalities
originalities1464885originalities
parfocalities2053715parfocalities
partialities14108035parti_alities
penalities121313475___penalities
perspicacities2261995perspicacities
practicalities2053565practicalities
primalities1548295__primalities
prodigalities1763935prodigalities
quizzicalities3361285quizzicalities
rascalities1347225__rascalities
rationalities1357285rat_ionalities
socialities1349295_soci_alities
spatialities1465565spati_alities
specialities1656795__specialities
stabilities13511785stabi__lities
sterilities11129015steri__lities
stupidities1453645stupi__dities
tactilities1347675tacti__lities
tangibilities1655485tangibilities
technicalities2161955technicalities
temporalities1753495temporalities
tepidities1347715_tepi__dities
theatricalities2061685theat_ricalities
tonalities101711735_t__onalities
tonicities12410365_tonic__ities
topicality1744485_topicalit__y
totalities101210785_t__otalities
toxicities1947285_toxic__ities
trivialities1555225_trivialities
tropicalizes2554125tropicali_zes
typhlitis1753325_typ__hliti_s
typhlitises1952375_typ__hlitises
typicalness1852575_typical_ness
typicalnesses2062545_typicalnesses
utilities9610805ut__i__lities
venialities14168935_veni_alities
veridicalities2063065veridicalities
vitalities1349095___vitalities
vocalities1549395___vocalities
whimsicalities2461735whimsicalities

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.403443402.0
2DLD Change Limit1247901077.92315750.3
3Display Results1071070.0801337.5
 (SQL Overall)1786911078.40621257.6
 
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.