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 “priests” 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.

470 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
priests9381086(None) 
prests84021261pr_ests
priest84125421priest_
arrests73312682arrests
crests85218702cr_ests
driest74722752driest_
grists74716482gri_sts
orients7311582orients
pests75933272p__ests
presets94216422pr_esets
press75425952pr_es_s
prest75736352pr_est_
presto84216202pr_esto
prestos93716082pr_estos
pretests10310012pretests
priers84521192prie_rs
pries74339532prie__s
priested1138392priested
priestess1145292priestess
priestly1345842priestly
prints84320102pri_nts
prises84133172pri_ses
prisms104915502pri_sms
priss74623892pri_s_s
prisses94816712prisses
privets122910052privets
protests10310492protests
purists94014072puri_sts
reests64618892_reests
rests54935872_r_ests
spriest92718652spriest_
wrests95313082wr_ests
wriest94419712wriest_
wrists95415642wri_sts
aeriest73924053aeriest_
ageists848493ageists
agists75713173agi_sts
airest63825263airest_
airiest74221013airiest_
aorists74215833aori_sts
aperients1178253aperients
apricots1275393apricots
argents84014853argents
aridest8316143aridest_
ariels65119373arie_ls
arietta788903arietta
ariettas847393ariettas
ariette7312373ariette
ariettes8411353ariettes
ariosos7409853ariosos
arises65233803ari_ses
arista6415293ari_sta
aristas7413523ari_stas
aristo6414033ari_sto
aristos7312373ari_stos
armets84918353arme_ts
armrests1055383armrests
arpents93613083arpents
arrest63722633arrest_
artiest73121993artiest_
artists74215593artists
attests7278813attests
aurists74615783auri_sts
behests1235953behests
bests75932613__bests
breasts939703breasts
brents84717273br_ents
briefs115510073brie_fs
briers85319733brie_rs
bries74942153brie__s
brights133710233brights
brises84927613bri_ses
brisks124611403bri_sks
briss75824273bri_s_s
brisses94314313brisses
brits76433083bri__ts
britts84813443bri_tts
chests114916263_chests
cists76624533_ci_sts
clients938093clients
creeses93914623creeses
cress75022833cr_es_s
crest74632693cr_est_
criers83918583crie_rs
cries75438403crie__s
crises84529433cri_ses
crisis83716343cri_sis
crisps104411513cri_sps
crista8311803cri_sta
crits75527573cri__ts
cruets85314953crue_ts
crusets93811043crusets
crusts84916543cr_usts
deists74916433dei_sts
detests83711743detests
devests114410473devests
dieses75218693_dieses
diesis74013493_diesis
diets66026643_die_ts
digests93610613digests
directs102710263directs
direst75024243direst_
divests114510933divests
dress65319833dr_es_s
drest65530343dr_est_
driers74516733drie_rs
dries64733673drie__s
drifts10499893dri_fts
dryest104811123dryest_
earnests837853earnests
eeriest73620673eeriest_
egests74411253_egests
epeeists1044793epeeists
erects84116183er_ects
exists134710913exi_sts
feists94915313fei_sts
fests85828043__fests
fiesta938123_fiesta
fiestas1038433_fiestas
firsts95110923_firsts
fists85527543_fi_sts
fliest94718433fliest_
foists95413983foi_sts
forests104114953forests
freest95318283freest_
frets85523403fr_e_ts
friends11396743friends
friers94718933frie_rs
fries85535603frie__s
friezes19418913friezes
frights14339623frights
frisees104411693frisees
frises94124273fri_ses
frisks13479263fri_sks
frits86129103fri__ts
fritts94613193fri_tts
frosts94214623fr_osts
frowsts13426103frowsts
geests75912163_geests
gests66028813__gests
gists66026193_gi_sts
goriest82218743goriest_
greats76318393gr_eats
greets75117423gr_eets
griefs10418723grie_fs
grieves1137323grieves
grifts104511683gri_fts
grilses8319153grilses
griots74713643gri_ots
grist65529873gri_st_
grits65529583gri__ts
grivets11357973grivets
guests74311203_guests
harvests14246173harvests
heists96814633hei_sts
hests85829933__hests
hists86328373_hi_sts
hoists95516023hoi_sts
iciest82914743iciest_
imprests1246313impr_ests
incests92711383incests
infests10279793infests
ingests83210983ingests
invests10319683invests
irises64221173iri_ses
jests125922453__jests
joists134711033joi_sts
jurists14409123juri_sts
kists95822113_ki_sts
krises105016083kri_ses
latests73910313latests
lists56628693_li_sts
lyrists1036963lyri_sts
maists85817573mai_sts
midsts95510053_midsts
miriest93619823miriest_
mists76633903_mi_sts
molests93311563molests
nests55728003__nests
obtests9136233obtests
odists749853odi_sts
orbiest9312413orbiest_
orgeats838353orgeats
orgiasts943803orgiasts
oriels64914623orie_ls
orient6322533orient_
paciest112917813paciest_
paints85921833pai_nts
paisas84317493pai_sas
palest83926223palest_
palets85122313pale_ts
paliest93021613paliest_
papists112110453papists
parents93418123parents
pareses94718883pareses
paresis93315093paresis
pargets105215193parge_ts
paries84742513parie__s
parietes10714543parietes
parises94827183pari_ses
pasts75936503p__asts
patents94815203patents
patients1088763patients
peats76140193p__eats
peises84125043pei_ses
pelts76128813p__elts
percents122713373percents
percepts14247643percepts
perfects15107353perfects
periapts1237273periapts
peridots1138323peridots
perkiest143313243perkiest_
perpents122312043perpents
persists1049183persists
pertest9317043pertest_
perverts1337533perverts
pesos77221623p__esos
pest65555293p__est_
pesto75723723p__esto
pestos84719083p__estos
pesty106421713p__esty
pets66248333p__e_ts
picots104616443p_icots
pieces104217273p_ieces
piers75926333p_ie_rs
pies66949603p_ie__s
pieta75421753p_ie_ta
pietas84516503p_ietas
pietists1038323p_ietists
piety105817303p_ie_ty
pigsty1235933p_igsty
pilots84018873p_ilots
piniest93121133piniest_
pinots85920273p_inots
pints75936223p_i_nts
pipets105714773p_ipets
pipiest113114503pipiest_
pipits104713063p_ipits
pisos76021063p_i_sos
piss65033333p_i_s_s
pisses84525083p_isses
piste75824603p_i_ste
pistes85325633p_i_stes
pits66348743p_i__ts
pivots115111903p_ivots
pleats85218593p_leats
pliers84715153plie_rs
plies74526513plie__s
plights13299313plights
plisses94411773plisses
podesta1036763podesta
podestas1146853podestas
poets76024443p_oe_ts
points85618533poi_nts
poisers94214433poisers
poises84226543poi_ses
pokiest133314913pokiest_
porisms113713453pori_sms
porkiest143513713porkiest_
porniest103214313porniest_
portents103512823portents
possets94212773possets
posts75228783p__osts
poxiest163412253poxiest_
praisers103410833praisers
praises94121103praises
prases84429023pr_ases
prats76333393pr__ats
preacts113211363preacts
precasts1239453precasts
precents123015043precents
precepts14268893precepts
precess11310863preces_s
precis103416703pr_ecis
precuts111710473precuts
predigests1443663predigests
preedits1168763preedits
preempts1444543preempts
preens85020113pr_eens
prees75937173pr_e_es
preexists1844733preexists
prefects1598133prefects
preheats1339413preheats
prelects1299723prelects
preops104911943pr_eops
preps96220693pr_e_ps
presa74319043pr_es_a
prese75228383pr_es_e
presents103315643presents
preset84430983pr_eset
presifts1366593pr_esifts
presorts105311683pr_esorts
presses93523153presses
prester93519623pr_ester
presters103419003pr_esters
pretest9517633pretest_
pretexts1735603pretexts
pretty11510873pr_etty
prevents133012293prevents
prexes154915953pr_exes
preys105717783pr_e_ys
prezes173614693pr_ezes
priapus1134353priapus
pricers113915063pricers
prices104524543pri_ces
priciest122112903priciest_
prickets16329083prickets
pricks144414263pri_cks
prides94324183pri_des
pried84426863prie__d
prier75027763prie__r
priesting1239483priesting
prigs85219703pri__gs
prills84015613pri_lls
primas104418103pri_mas
primate111516283primate
primates121515933primates
primeros12336883primeros
primers114215673primers
primes104225263pri_mes
primmest14226693primmest_
primness1276763primnes_s
primos104514423pri_mos
primps124711823pri_mps
prims95425933pri__ms
primsie1137543primsie
primus103712173pri_mus
primuses1237083primuses
princes113015143princes
princess12266803princes_s
prinks124315383pri_nks
print74837463pri_nt_
prions84317783pri_ons
prioress1035393priores_s
priors83914483pri_ors
prise74632613pri_s_e
prised94322203pri_sed
prisere9310943prisere
priseres10310823priseres
prism94820263pri_s_m
prison8514023pri_son
prisons9313223prisons
prissed103311263prissed
prissies101712003prissies
prissy11347853pri_ssy
private121513263private
privates131812373privates
privet113821343privet_
privies122414263privies
priviest132310313priviest_
privity15268313privity
prizers183911843prizers
prizes173819813pri_zes
probits112712573probits
process11310403proces_s
proems104711163proe_ms
proestrus1144843proestrus
proette9312363proette
proettes10312763proettes
profess1237713profes_s
profits122911243profits
projects1936413projects
projets1639163projets
prompts1337473prompts
prosects1239473prosects
prosers94219643prosers
proses84733473pr_oses
prosiest10416523prosiest_
prosos85718553pr_osos
pross76529403pr_os_s
prosses94019513prosses
prost75434103pr_ost_
protects1239743protects
protest9317533protest_
protists10313363protists
provosts1336083provosts
prowess1237903prowes_s
prowest12311533prowest_
pryers115012243prye_rs
puniest92918093puniest_
purest84021933purest_
purisms114110833puri_sms
purist85525053puri_st_
pursiest102812123pursiest_
purtiest102414113purtiest_
quests153310353_quests
quiets154014373quie_ts
reest54938093_reest_
renests74014213renests
rents55935183_r_ents
resets65427613_r_esets
resits64725563_r_esits
rest46459843_r_est_
retests73813853retests
rets45352563_r_e_ts
revests104413733revests
rhesus936203_rhesus
riels55121333_rie_ls
rifest93114583_rifest_
rifts85718643_ri_fts
rights104019333_rights
rinses64720383_rinses
riots54922013_ri_ots
ripest84317943_ripest_
riposts9279403_riposts
risers64624783_risers
rises55244043_ri_ses
risks94917063_ri_sks
risus54216393_ri_sus
rivets94417113_rivets
roasts64915413_roasts
roosts64916323_roosts
rosets65819953_rosets
rousts617016723_rousts
rusts55026993_r_usts
shiest95821533shiest_
shists96515113shi_sts
siesta639503_siesta
siestas738813_siestas
sliest66621963sliest_
spiriest102513463spiriest_
sprights14167143sprights
sprints94113773spri_nts
sprits85122533spri__ts
spryest12247813spryest_
tests56530193__tests
theists1039153theists
thirsts1036243thirsts
treats64821693tr_eats
tress55423163tr_es_s
trets55928023tr_e_ts
tricots9311563tricots
tridents938583tridents
trienes74118413trienes
triens65417543trie_ns
trientes82812123trientes
triers64321523trie_rs
tries55742813trie__s
trijets14308263trijets
trioses75015653trioses
trisects1035983trisects
triste63818643tri_ste
tritest7315273tritest_
trivets103911583trivets
truest64816193truest_
trusts64714433tr_usts
trysts9448793tr_ysts
twists9549753twi_sts
unrests7229463unrests
uprights14145313uprights
uprisers10206773uprisers
uprises92012733upri_ses
urtexts1433143urtexts
veriest103719133veriest_
verists103613673veri_sts
vests85325983__vests
waists97415453wai_sts
wariest105122503wariest_
wests85727003__wests
whists124613813whi_sts
wiriest103816853wiriest_
wists86728523_wi_sts
wrest84925433wr_est_
wries85827743wrie__s
wrights14318993wrights
wrist84827563wri_st_
wristy12509703wri_sty
writs86624383wri__ts
wryest12429113wryest_
zests145419743__zests

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 Filter1786911340270.546327272.9
2DLD Change Limit1340274709.00014891.9
3Display Results4704700.3301424.2
 (SQL Overall)1786914709.87618093.5
 
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.