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

263 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
priested113839(None) 
arrested939152arrested
crested103416532cr_ested
oriented937482oriented
pressed103317312pr_essed
prester93519622pr_ester
pretested12149112pretested
priest84125422priest__
priestess1145292priestess
priestly1345842priestly
priests93810862priest_s
printed104016372pri_nted
prised94322202pri_s_ed
prissed103311262pri_ssed
protested12159112protested
reested82916232_reested
rested74430782_r_ested
wrested113410932wr_ested
agisted938203agi_sted
ariette7312373ariette_
ariettes8411353ariettes
arrestee849443arrestee
arrester839253arrester
attested936293attested
bested94922763__bested
bilsted1038033_bilsted
breasted1138823breasted
briefed1335743brie_fed
brisked144210003bri_sked
bristled11187343bri_stled
chested133811673_chested
cisted95217523_ci_sted
created104323453cr_eated
creeshed1435693creeshed
crisped124010103cri_sped
crusted103712753cr_usted
detested10279623detested
devested13239133devested
diester83013683_diester
dieted83115493_die_ted
digested11208163digested
directed1238233directed
divested13268213divested
dressed93511873dr_essed
driest74722753driest__
drifted12367953dri_fted
egested938123_egested
erected103213993er_ected
existed1538473exi_sted
fisted104218703_fi_sted
foisted113210603foi_sted
forested12312463forested
freshed143312593fr_eshed
fretted113411853fr_etted
friended1335033friended
frighted1657173frighted
frisked15478823fri_sked
fritted113611333fri_tted
frosted113211873fr_osted
frowsted1534313frowsted
greeted93111383gr_eeted
grieved1235283grie_ved
grifted12379583gri_fted
grister83915413gri_ster
gritted94110903gri_tted
guested9157713_guested
harvested1644093harvested
heisted113210653hei_sted
histed104420243_hi_sted
hoisted113411293hoi_sted
infested12249643infested
ingested10259003ingested
invested12229693invested
irised73913153iri_s_ed
jested144416503__jested
joisted15379173joi_sted
kiester11329973_kiester
listed74322833_li_sted
misted93625823_mi_sted
molested11178243molested
nested74720063__nested
obtested1135453obtested
orienter838313orienter
painted104214633pai_nted
parented11912213parented
pargeted1238683parge_ted
pargetted1345663pargetted
parietes10714543parie_tes
pasted94426903p__asted
patented1188893patented
peised94817683pei_s_ed
pelted94617763p__elted
perfected1736643perfected
periostea1144783periostea
perished14310083peri_shed
permeated1439373permeated
persisted1247143persisted
perverted1546103perverted
pester84827593p__ester
pestled102711453p__estled
petted94121523p__etted
piaster93012883p_iaster
picoted1239213p_icoted
pieced113912103p_ie_ced
pierced12347593p_ierced
pileated112711133pileated
piloted10310323p_iloted
pipestem1443743pipestem
pipetted1335263pipetted
pirated102515613p_irated
pished124817063p_i_shed
pissed94816933p_i_ssed
piste75824603p_i_ste_
pistes85325633p_i_stes
pitted94319593p_i_tted
pivoted1336513p_ivoted
pleated103816633p_leated
plicated13310643plicated
plighted1546463plighted
pointed103813983poi_nted
poised94918473poi_s_ed
posted93722493p__osted
praised104214813prais_ed
prated94924923pr__ated
preacted132710943preacted
preaged11612333pr_eaged
precented14310693precented
precessed1437523precessed
precited133013813precited
predated12513273predated
predigested1653073predigested
preed85128123pr_e__ed
preedited1337633preedited
preempted1644683preempted
preened103214993pr_eened
preexisted2043783preexisted
preheated1539813preheated
prelected1439133prelected
premed114617763pr_e_med
prepasted14137673prepasted
prepped11329903pr_epped
presaged1238803pr_esaged
prese75228383pr_es_e_
presented12311633presented
preset84430983pr_es_et
presets94216423pr_esets
preside10715613pr_eside
presided12410553pr_esided
presifted1536873pr_esifted
presold1059603pr_esold
presorted1239453pr_esorted
presser93717623pr_esser
presses93523153pr_esses
prest75736353pr_est__
presters103419003pr_esters
presto84216203pr_est_o
prestored125111673pr_estored
prestos93716083pr_estos
prests84021263pr_est_s
presumed1337973pr_esumed
pretasted12147963pretasted
pretend104011013pr_e_tend
pretexted19135693pretexted
prettied1159253pr_ettied
prevented1539003prevented
prevued1337143pr_evued
preyed125313203pr_e_yed
priced115018883pri__ced
pricked164613833pri_cked
prickled17358073prickled
prided103618033pri__ded
pried84426863pri___ed
priedieu1153983priedieu
pries74339533pries___
priesthood1652163priesthood
priesting1239483priesting
priestlier1242883priestlier
prigged12398933pri_gged
prilled104713003pri_lled
primate111516283primate_
primates121515933primates
primed115118913pri__med
primmed14388853pri_mmed
primped14479153pri_mped
primsie1137543primsie_
prinked143412163pri_nked
printer93917303pri_nter
prise74632613pri_s_e_
prisere9310943prisere_
priseres10310823priseres
prises84133173pri_s_es
prisoned1138813prisoned
prisses94816713pri_sses
prissier10157873prissier
prissies101712003prissies
private121513263private_
privater13158533privater
privates131812373privates
prized184415393pri__zed
probated13410863probated
processed1446803processed
proette9312363proette_
proettes10312763proettes
professed1545243professed
profited14279973profited
projected21165823projected
promoted13310543promoted
prompted1536903prompted
pronated11414053pronated
prorated11513713prorated
prosected14158633prosected
prosed94921093pr_os_ed
protected14158653protected
protester111510483protester
quested17168383_quested
quieted17309723quie_ted
renested92212953renested
rented74426593_r_ented
reseed74823293_r_eseed
resited85122423_r_esited
rester63832433_r_ester
retested92212533retested
retted74826313_r_etted
revested122612243revested
rifted104115313_ri_fted
righted122912143_righted
rimester1037813_rimester
rinsed75016353_rins_ed
rioted73416373_ri_oted
riposted11216933_riposted
risked115514633_ri_sked
riveted11258573_riveted
rivetted12226093_rivetted
roasted83912663_roasted
roosted83211883_roosted
rousted84013323_rousted
rusted75020923_r_usted
spriest92718653spriest__
sprinted113411163spri_nted
tested74421523__tested
thirsted1235213thirsted
treated83618703tr_eated
tressed83714263tr_essed
trientes82812123trientes
trimester1145823trimester
trisected1244913trisected
triste63818643tri_ste_
trusted83412793tr_usted
trysted11428273tr_ysted
twisted11277433twi_sted
unrested91914513unrested
untested92612413untested
unvested122210223unvested
uprighted1654213uprighted
urinated9311613urinated
vested104217353__vested
waisted114210943wai_sted
whisted144010013whi_sted
wisted104120273_wi_sted
wrester102812413wr_ester
wrestled12296763wr_estled
wriest94419713wriest__
zested164214043__zested

Search took 9 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.436409841.7
2DLD Change Limit1461622637.81318707.5
3Display Results2632630.0932828.0
 (SQL Overall)1786912638.34221420.6
 
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.