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
artificialness1971394artificial_ness
atypicalities2052684a_typic_alities
criticalities1754674cr_itic_alities
antisexualities2263475antisexualities
artificial1553925artificial_____
artificially2052495artificial___ly
criminalities1754735cr_imi_nalities
ethicalities1754435_et_hic_alities
farcicalities2053575far__cic_alities
originalities1464885or_igi_nalities
parfocalities2053715par__foc_alities
partialities14108035part____ialities
partibilities1748095part__ibi_lities
practicalities2053565practic_alities
principalities2083205pr_incipalities
provincialities2262255provincialities
rationalities1357265rat__ionalities
risibilities1448625_r_isibi_lities
topicalities1655585__topic_alities
triaxialities2063045tr_i_axialities
trivialities1555215__t_rivialities
typicalities1954155__typic_alities
veridicalities2063065veridic_alities
verticalities1885215vert__ic_alities
actabilities1649986act__abi_lities
actualities1346826act____ualities
admirabilities1956026admirabi_lities
admissibilities2063276admissibi_lities
advisabilities2055546advisabi_lities
affabilities2046946a__ffabi_lities
alterabilities1667336alterabi_lities
ambisexualities2682226ambisexualities
amiabilities16109876a_mi_abi_lities
amicabilities19197896a_micabi_lities
animalities1348976a___ni_malities
antigenicities1763716antigeni_cities
antigravities1763076ant__igravities
antisocialists16114796antisociali_sts
arabilities13413096ar___abi_lities
articulacies1664786art__ic_ulacies
articulates1349046art__ic_ulat_es
artifices1446476artific______es
atomicities1545936a_tomic___ities
atonalities1148396a_t___onalities
atonicities1346676a_tonic___ities
attainabilities1753756attainabi_lities
audibilities1546636a__udibi_lities
automobilities1862886automobi_lities
availabilities1955746availabi_lities
axialities1747726a_____xialities
cardinalities1654356car__di_nalities
certificates1992896certific_a__t_es
classicalities1862536classic_alities
codifiabilities2383036codifiabilities
comicalities1846956__comic_alities
commercialities2363306commercialities
convivialities2262776_convivialities
corrigibilities2092766corrigibi_lities
credibilities1856066cr_edibi_lities
cyclicalities1953036_cyclic_alities
divisibilities2064056divisibi_lities
drivabilities1947246dr_ivabi_lities
efficacities2252196__effic_acities
eligibilities1655646_eligibi_lities
equivocalities28112066equivoc_alities
erodibilities1656886er_odibi_lities
facilities1549826____faci_lities
fatigabilities2065376fatigabi_lities
finalities1349886____fi_nalities
frangibilities2054036frangibi_lities
friabilities1789156fr_i_abi_lities
gracilities1447676gr___aci_lities
homosocialities2292066homosocialities
illogicalities17132526illogic_alities
individualities2063106individualities
invisibilities1956116invisibi_lities
irascibilities1854816irascibi_lities
irrationalities1563126irrationalities
irritabilities1647296irritabi_lities
lexicalities2154726__lexic_alities
logicalities1555056__logic_alities
marginalities1654326mar__gi_nalities
materialities1566396mat__erialities
modifiabilities2382846modifiabilities
municipalities2062576munici_palities
musicalities1655826__music_alities
nationalities1356896nat__ionalities
notionalities1355926not__ionalities
optimalities1654666opt__i_malities
optionalities1574546opt__ionalities
orthogonalities1991946orthogonalities
particularities1993376parti_cularities
physicalities2393636_physic_alities
potentialities1674196pot_entialities
primalities1548286pr___i_malities
primitivities2073566pr_imiti_vities
prodigalities1763936pr_odi_galities
prolificities2053476prolific___ities
quizzicalities3361286quizzic_alities
rascalities1347206_r__asc_alities
ratification17810666ratific_a__tion
ratifications1899786ratific_ati_ons
socialities1349286____socialities
specialities1656776___specialities
spiritualities1663696_spiritualities
technicalities2161956technic_alities
trainabilities1646596trainabi_lities
variabilities1848636var_i_abi_lities
verifiabilities2354436verifiabilities
visibilities1747376__visibi_lities
whimsicalities2461736whimsic_alities

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 Filter178691950240.203880251.2
2DLD Change Limit950241139.17310359.1
3Display Results1131130.0931215.1
 (SQL Overall)1786911139.46918871.2
 
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.