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

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

302 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
parietes1071455(None) 
aretes64425362_ar_etes
ariettes8411352_ariettes
barites94322342bari_tes
pareses94718882par_eses
pargeted1238682pargeted
pargets105215192parget_s
paries84742522pari__es
parietal1048782parietal
parietals1146872parietals
parises94827192pari_ses
parishes13314762parishes
parities10522982parities
parkettes15137592parkettes
patriates11311372patriates
pyrites12812202pyri_tes
variates111214992variates
varieties1259212varieties
apatites10311293apati_tes
aplites9314933apli_tes
arbutes939703_arbutes
arenes64928393_ar_enes
arete56031353_ar_ete_
ariels65119373_arie_ls
arietta788903_arietta
ariettas847403_ariettas
ariette7312373_ariette
arises65233803_ari_ses
aristas7413533_aristas
aristos7312393_aristos
armets84918353_armet_s
artistes83213363_artistes
aviates10313083_aviates
axites134913833_axi_tes
barbets114915853barbet_s
barbettes1348173barbettes
bareges105212033bar_eges
bargees105415873barge_es
baristas1039733baristas
barite84224813bari_te_
barrets94917113barret_s
barrettes1149073barrettes
barytes124611153bar_ytes
batistes1039713batistes
carates95630613car_ates
carets85330773car_et_s
caribes113715643cari_bes
carices114220953cari_ces
caries85147623cari__es
carioles10817083carioles
caritas93316963cari_tas
carnets93918403carnet_s
carpeted1338963carpeted
carpets113915333carpet_s
cartes86239473car__tes
cerites94823433ceri_tes
curites93919863curi_tes
dacites101114593daci_tes
darioles9710703darioles
earpieces1343353earpieces
friezes19418913_friezes
frites94922483_fri_tes
gaieties9310183ga_ieties
gametes10312253ga_metes
gargets94614573garget_s
garigues1034963garigues
garnets84115413garnet_s
garotes8614573gar_otes
garottes978293garottes
garreted1057523garreted
garrets84413623garret_s
garrotes969383garrotes
grieves1137323_grieves
halites103221193hali_tes
jadeites1645823jadeites
karates115617473kar_ates
labiates101011523labiates
larees65323113lar_e_es
lariated91212063lariated
lariats7615063lariat_s
machetes1539633machetes
marinates112516393marinates
marines93928043mari_nes
marishes13512553marishes
marketed1537323marketed
marketer1437383marketer
marketers1545993marketers
markets133314033market_s
marlites103415283marlites
marmites122212803marmites
muriates10312093muriates
naivetes1145113naivetes
narrates8312763narrates
norites74018803nori_tes
pacifies15311233pacifies
packeted17148293packeted
packets155114773packet_s
paginates123111373paginates
painted104214633pa_inted
painter93814563pa_inter
painters103013033pa_inters
paints85921833pa_int_s
palates93624943pa_lates
palets85122313pa_let_s
palettes103112833palettes
palleted1139873palleted
pallets93919303pallet_s
pallettes1148803pallettes
palliates11311043palliates
palmettes1346883palmettes
palpates122613063palpates
pangenes112612833pangenes
panicles121010133panicles
paniers94717333panie_rs
papists112110453papist_s
parables121613573parables
paracletes1446113paracletes
parades104121473par_ades
parakeets1545113parakeets
parakites1549553parakites
parameter1349123parameter
parameters1448133parameters
parapeted1446483parapeted
parapets1239773parapet_s
parasites11313163parasites
parbakes1638343parbakes
parceled1338343parceled
parcels113712663parce_ls
parcener1238473parcener
parceners1337473parceners
parches143720003par_ches
pardee93922023parde_e_
pareiras1038193pareiras
parented11912213parented
parents93418133par_ents
pareos87023773par_e_os
parers85530743par_e_rs
pares77164483par___es
paresis93315093par_esis
paretic113016673par_etic
paretics122312443par_etics
pareus85420743par_e_us
pareve114613013par_eve_
parges94529543par__ges
parget94529393parget__
pargetted1345663pargetted
pariahs123812343pari_ahs
parians93519743pari_ans
parings104219223pari_ngs
paris75145943pari___s
parity114719873pari_t_y
parkades1538273parkades
parkers133816873parke_rs
parkette14138023parkette
parles86334413par__les
parleyed1436243parleyed
parleyer1335633parleyer
parleyers1444713parleyers
parleys125212383parle_ys
parodies11313693parodies
parolees104313993parolees
paroles95025893par_oles
parqueted2144223parqueted
parquets1936423parquet_s
parrels94713493parre_ls
parridges1384563parridges
parriers103612913parrie_rs
parries93925853par_ries
parroted1158853parroted
parroter1058213parroter
parroters1156773parroters
parrots9312743parrot_s
parsecs11429923parse_cs
parsers94118153parse_rs
parses85534703par__ses
partakes1449923partakes
parted94228683par__ted
parterres1148083parterres
particles1339813particles
partiers103514253partie_rs
parties93230873par_ties
partitas10310263partitas
partite9317133partite_
partlets102811523partlet_s
parts77743373par__t_s
parures9512693par_ures
parvenues1444653parvenues
parvenus1335663parvenus
parvises133911923parvises
pastes85233913pa__stes
pates76047893pa___tes
patiences1367443patiences
patienter1145563patienter
patientest1245723patientest
patients1088773patients
patinates113814703patinates
patines95225773pati_nes
patriate10311933patriate_
patriated1238543patriated
patriots1038063patriot_s
paupiettes1442603paupiettes
pavises125315493pavi_ses
pavisses13397103pavisses
pawnees12298173pawne_es
payees114812903pa_ye_es
pearlites1138233pearlites
pelites93821993peli_tes
perigees1189503perigees
perimeter1349563perimeter
perimeters1448603perimeters
peripeties1448403peripeties
peripter1278753peripter
peripters1368123peripters
periques1937663periques
perishes13313753perishes
peritus9311803peri_tus
perlites10316363perlites
permeates13311773permeates
permutes1238713permutes
petites93820203peti_tes
pharisees1444633pharisees
picrites121811083picri_tes
pieces104217273p__ieces
pietas84516503p__ietas
pieties9419223p__ieties
pinites9319533pini_tes
pirates93020333pir_ates
pistes85325633p__istes
podites103014733podi_tes
pointes93216753p_ointes
portieres1138223portieres
prairies10411463prairies
praises94121113prai_ses
prates84633163p_r_ates
prees75937173p_r_e_es
pretest9517633p_r_etest
prexes154915953p_r_exes
prezes173614693p_r_ezes
prices104524543p_ri_ces
prides94324183p_ri_des
priers84521193p_rie_rs
pries74339533p_ri__es
priested1138393p_riested
priestess1145293p_riestess
priests93810863p_riests
primates121515933p_rimates
primes104225263p_ri_mes
princes113015153p_rinces
printed104016373p_rinted
printer93917303p_rinter
printers103214913p_rinters
prints84320103p_rint_s
priseres10310823p_riseres
prises84133173p_ri_ses
prisses94816713p_risses
privates131812383p_rivates
privets122910053p_rivet_s
privies122414263p_rivies
prizes173819813p_ri_zes
proettes10312763p_roettes
purees84721683pur_e_es
purifies13311933purifies
purines94420773puri_nes
purists94014073purist_s
purities10316283purities
pyrenes123511223pyr_enes
pyrexes19305843pyr_exes
pyrite11913313pyri_te_
radiates92415303radiates
rarifies11311943rarifies
rarities8316333rarities
ratites74920683rati_tes
rites54442553__ri_tes
samites93118713sami_tes
sarees65329943sar_e_es
satiates8314633satiates
satieties939383satieties
scrieves13387613scrieves
seriates82620683seriates
shrieves14297093shrieves
sorites73825243sori_tes
sprites94220333spri_tes
striates83417093striates
targeted1037483targeted
targets84314223target_s
taxites1449673taxi_tes
trienes74118413_trienes
trientes82812133_trientes
variate101316433variate_
variated121211393variated
varices123313573vari_ces
variegates1444043variegates
variers103712663varie_rs
varies94330873vari__es
varietal1145613varietal
varietals1244443varietals
variety1337743variet_y
varioles11711133varioles
varlets10411573varlet_s
verites103822263veri_tes
writes94420333_wri_tes
yperites13310153yperi_tes

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.420425454.8
2DLD Change Limit1461623026.90621164.5
3Display Results3023020.1262396.8
 (SQL Overall)1786913027.45223978.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.