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

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

113 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
artificialities206196(None) 
artificiality2161893artificialit__y
artificialness1971404artificial_ness
atypicalities2052684a_typic_alities
criticalities1754684cr_itic_alities
antisexualities2263485antisexualities
artificial1553925artificial_____
artificially2052505artificial___ly
criminalities1754745cr_imi_nalities
ethicalities1754445_et_hic_alities
farcicalities2053575far__cic_alities
originalities1464885or_igi_nalities
parfocalities2053715par__foc_alities
partialities14108035part____ialities
partibilities1748095part__ibi_lities
practicalities2053565practic_alities
principalities2083205pr_incipalities
provincialities2262255provincialities
rationalities1357285rat__ionalities
risibilities1448645_r_isibi_lities
topicalities1655585__topic_alities
triaxialities2063045tr_i_axialities
trivialities1555225__t_rivialities
typicalities1954155__typic_alities
veridicalities2063065veridic_alities
verticalities1885215vert__ic_alities
actabilities1649996act__abi_lities
actualities1346826act____ualities
admirabilities1956056admirabi_lities
admissibilities2063326admissibi_lities
advisabilities2055576advisabi_lities
affabilities2046946a__ffabi_lities
alterabilities1667336alterabi_lities
ambisexualities2682226ambisexualities
amiabilities16109896a_mi_abi_lities
amicabilities19197916a_micabi_lities
animalities1348996a___ni_malities
antigenicities1763716antigeni_cities
antigravities1763086ant__igravities
antisocialists16114816antisociali_sts
arabilities13413106ar___abi_lities
articulacies1664786art__ic_ulacies
articulates1349046art__ic_ulat_es
artifices1446476artific______es
atomicities1545956a_tomic___ities
atonalities1148406a_t___onalities
atonicities1346686a_tonic___ities
attainabilities1753756attainabi_lities
audibilities1546646a__udibi_lities
automobilities1862906automobi_lities
availabilities1955756availabi_lities
axialities1747736a_____xialities
cardinalities1654376car__di_nalities
certificates1992906certific_a__t_es
classicalities1862536classic_alities
codifiabilities2383046codifiabilities
comicalities1846976__comic_alities
commercialities2363316commercialities
convivialities2262776_convivialities
corrigibilities2092766corrigibi_lities
credibilities1856076cr_edibi_lities
cyclicalities1953036_cyclic_alities
divisibilities2064066divisibi_lities
drivabilities1947266dr_ivabi_lities
efficacities2252196__effic_acities
eligibilities1655646_eligibi_lities
equivocalities28112076equivoc_alities
erodibilities1656886er_odibi_lities
facilities1549826____faci_lities
fatigabilities2065386fatigabi_lities
finalities1349906____fi_nalities
frangibilities2054036frangibi_lities
friabilities1789176fr_i_abi_lities
gracilities1447686gr___aci_lities
homosocialities2292066homosocialities
illogicalities17132526illogic_alities
individualities2063106individualities
invisibilities1956146invisibi_lities
irascibilities1854836irascibi_lities
irrationalities1563126irrationalities
irritabilities1647326irritabi_lities
lexicalities2154726__lexic_alities
logicalities1555056__logic_alities
marginalities1654326mar__gi_nalities
materialities1566396mat__erialities
modifiabilities2382856modifiabilities
municipalities2062576munici_palities
musicalities1655826__music_alities
nationalities1356916nat__ionalities
notionalities1355926not__ionalities
optimalities1654666opt__i_malities
optionalities1574546opt__ionalities
orthogonalities1991946orthogonalities
particularities1993376parti_cularities
physicalities2393646_physic_alities
potentialities1674206pot_entialities
primalities1548296pr___i_malities
primitivities2073566pr_imiti_vities
prodigalities1763936pr_odi_galities
prolificities2053476prolific___ities
quizzicalities3361286quizzic_alities
rascalities1347226_r__asc_alities
ratification17810666ratific_a__tion
ratifications1899786ratific_ati_ons
socialities1349296____socialities
specialities1656796___specialities
spiritualities1663696_spiritualities
technicalities2161956technic_alities
trainabilities1646616trainabi_lities
variabilities1848646var_i_abi_lities
verifiabilities2354446verifiabilities
visibilities1747386__visibi_lities
whimsicalities2461736whimsic_alities

Search took 8 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.346516448.0
2DLD Change Limit950241137.14013308.7
3Display Results1131130.0761486.8
 (SQL Overall)1786911137.56223630.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.