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

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

80 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
parietal104877(None) 
parietals1146861parietals
varietal1145611varietal
marital92314182mari_tal
parental10310942parental
parietes10714542parietes
varietals1244442varietals
acetal84314903_a_cetal
areal55928733_ar_e_al
argental947933_argental
ariel55228973_arie__l
arietta788903_arietta
ariettas847393_ariettas
ariette7312373_ariette
arista6415293_arista_
aristae7312533_aristae
aristas7413523_aristas
arsenal739383_arsenal
artal55525473_ar__tal
barbital1247053barbital
barista9310813barista_
baristas1039723baristas
basipetal1352383basipetal
capital112311523capi_tal
carceral1247193carceral
carinal94318233cari_nal
caritas93316953cari_tas
gametal1037603ga_metal
hartal9415473har__tal
lanital7310913lani_tal
narial6317953nari__al
oriental848483_oriental
paginal10269493pagi_nal
palatal9310153pa_latal
paleal84716673pa_le_al
paralegal1244973paralegal
parcel103915473parce__l
pareira937533pareira_
pareiras1038183pareiras
paretic113016673par_etic
parfocal1565393parfocal
parget94529393parget__
pargeted1238683pargeted
pargets105215193parget_s
pariah114320583pari__ah
parian83223963pari__an
paries84742513parie__s
parity114719873pari_t_y
parkette14138023parkette
parmesan1244753parmesan
parral85517533par__ral
parrel84515983parre__l
partan83820563par__tan
partial92616263par_tial
partita9310863partita_
partitas10310253partitas
pelletal1045733pelletal
percental1348663percental
peridial11411923peridial
perigeal1147553perigeal
perinatal1146483perinatal
perineal1049193perineal
perpetual1344483perpetual
petal76526893p___etal
pieta75421753p__ieta_
pietas84516503p__ietas
poriferal1444033poriferal
portal84218463por__tal
pretax152310193p_r_etax
primal104014623p_ri_mal
primatal1247133p_rimatal
primeval1544103p_rimeval
puritan939283puri_tan
rictal83113183__rictal
sagittal943283sagittal
shrieval1443363shrieval
societal1045723societal
tapetal938273ta_petal
tarletan845543tarletan
variety1337743variet_y

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 Filter1786911461620.423422437.4
2DLD Change Limit146162807.37319824.0
3Display Results80800.0332424.2
 (SQL Overall)178691807.82922824.2
 
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.