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

361 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
prevued133714(None) 
prevue1179161prevue_
prevues1239261prevues
peeved124112882peev_ed
preaged11612332preaged
precured1339992precured
preed85128112pre__ed
preened103214982preened
prefund1335732prefund
prelude1038012prelude
preluded1236452preluded
premed114617752pre_med
prepped11329892prepped
prequel1836342prequel
pressed103317302pressed
presumed1337962presumed
prevalued1544552prevalued
preview1536472preview
prevised143611072prevised
preyed125313192pre_yed
proved125016032prov_ed
revue81114452_revue_
revues9813902_revues
revved13469722_revved
argued84311173ar_gued
braved124817443brav_ed
bravoed13436113bravoed
breaded115014063breaded
breamed124011593breamed
breed85526693bre__ed
breezed19287053breezed
breve105317053brev_e_
breves115516423brev_es
brevet115717333brev_et
breveted1435623breveted
brevier1237763brevier
brewed125411873bre_wed
chevied16357483chevied
craved125417773crav_ed
creaked143413233creaked
creamed123913713creamed
creased104315583creased
created104323443created
creed85727393cre__ed
creeled104012013creeled
creeped12329713creeped
creped114115703cre_ped
crested103416533crested
creviced1634453creviced
crewed125316553cre_wed
dreaded103612023dreaded
dreamed114310633dreamed
dredged11346883dredged
dreed75222843dre__ed
dressed93511873dressed
droved114611643drov_ed
erected103213993erected
feued94715663_fe_ued
freaked15399703freaked
freed95223543fre__ed
freshed143312593freshed
fretted113411853fretted
graved114818813grav_ed
greased93812393greased
greaved12408913greaved
greed75125693gre__ed
greened93111263greened
greeted93111383greeted
greyed114610603gre_yed
grieved1235283griev_ed
groved114413703grov_ed
leveed104111373_leveed
levied104111433_levied
meoued9118533_meoued
nerved104111683nerv_ed
parented11912213parented
pareve114613013parev_e_
paved115525263p_av_ed
paveed12438893p_aveed
peaced115818913p_eaced
peaked136117403p_eaked
pealed95322803p_ealed
peched144915343p_eched
pecked155019103p_ecked
peed76239183p_e__ed
peeked134314573p_eeked
peeled94119703p_eeled
peened94318153p_eened
peeped113915383p_eeped
peered93819483p_eered
peeve104915253peev_e_
peeves113814873peev_es
pegged114811903p_egged
peined94918843p_eined
peised94817683p_eised
pelted94617753p_elted
pended103819013p_ended
penned94217613p_enned
pepped103113393p_epped
perched154713233perched
perdue93912633perdue_
perdues103511333perdues
perdured12287383perdured
perfumed1654533perfumed
perfused1445823perfused
periled10316293periled
perjured18286263perjured
perked134617683p_erked
permed115217343p_ermed
permuted1336703permuted
peruked14367883peruked
perused103112183perused
pervade1337023pervade
pervaded1535363pervaded
petted94121523p_etted
phreaked1834493phreaked
pieced113912103pie_ced
pierced12347593pierced
piqued1836213p_iqued
plagued11307473plagued
pleaded113511263pleaded
pleased103712073pleased
pleated103816633pleated
pledged12358613pledged
praised104214813praised
pranced123714043pranced
pranged114512553pranged
pranked143712093pranked
prated94924923pr_ated
prawned1346743prawned
prayed124815433pr_ayed
preached163412063preached
preacted132710943preacted
prearmed1397983prearmed
preaver121011613preaver
prebade12310283prebade
prebaked1737173prebaked
prebend12319443prebend
prebid113512843pre_bid
prebind123810643prebind
prebound1345893prebound
prebuild1344303prebuild
prebuy1357423prebu_y
prebuys1444393prebuys
precede1239633pre_cede
preceded1438283preceded
precised133213413precised
precited133013813precited
preclude1344903preclude
precluded1544203precluded
precode12311853precode
precoded1438863precoded
precure11312553precure
precures12312903precures
precut102016533precu_t
precuts111710473precuts
predated12513273predated
predried12309573predried
predusk1443773predusk
pree67044733pre__e_
preen75925053pre__en
preener93114833preener
prees75937173pre__es
prefaced1638423prefaced
prefade1339013prefade
prefaded1537823prefaded
prefer113813203pre_fer
prefiled143310573prefiled
prefired144310753prefired
prefixed21357693prefixed
prefunded1644693prefunded
prefunds1454693prefunds
preguide1255423preguide
preguided1443923preguided
prejudged2142743prejudged
preload1049813preload
preluder1135733preluder
preludes1137833preludes
premade12311443premade
premeds12389583pre_meds
premeet11615153premeet
premen105017803pre_men
premie103617993premie_
premier113515633premier
premies113823063premies
premised133013193premised
premixed20338003premixed
premold1247863premold
premune1138933premune
preowned1435213preowned
prepaid12310133prepaid
prepared132210863prepared
prepaved16177223prepaved
prepreg12165963prepreg
prepubes1436053prepubes
prepuce1337833prepuce
prepuces1438583prepuces
prepupa1064023prepupa
prequels1934833prequels
presaged1238803presaged
prese75228383pre_se_
preset84430983pre_set
preside10715613preside
presided12410553presided
presold1059603presold
presser93717623presser
presses93523153presses
pressured1237323pressured
prester93519623prester
presume11310303presume
presumer1247583presumer
presumes1239843presumes
pretaped13339133pretaped
preteen939873preteen
pretend104011013pretend
pretold1049083pretold
prettied1159253prettied
pretyped16306123pretyped
pretzel1835143pretzel
prevail1238243prevail
prevailed1536043prevailed
prevalue1345073prevalue_
prevalues1445323prevalues
prevent124016553prevent
prevented1539003prevented
preverb14317063preverb
previewed1843413previewed
previews1634513previews
previse123713793previse
previses133814283previses
prevuing1457253prevuing
prewired14358473prewired
prexes154915943pre_xes
prexies163415003prexies
preyer114413733pre_yer
prezes173614693pre_zes
priced115018883pr_iced
pricked164613833pricked
prided103618033pr_ided
pried84426863pr__ied
priested1138393priested
prigged12398923prigged
prilled104712993prilled
primed115118913pr_imed
primmed14388853primmed
primped14479153primped
prinked143412163prinked
printed104016373printed
prised94322203pr_ised
prissed103311263prissed
privet113821343priv_et
privier122910453privier
privies122414263privies
prized184415393pr_ized
probed114114823pr_obed
proceed12310543proceed
procured1336603procured
prodded1257733prodded
produced1456073produced
progged12409793progged
promoed12310083promoed
pronged113912393pronged
proofed13138723proofed
propped113311953propped
prosed94921093pr_osed
proud84615483pr_ou_d
prove104823193prov_e_
proven114314773prov_en
prover113819723prov_er
proves114322253prov_es
provide1339853provide
provided1536843provided
provoked1875053provoked
prowled13309903prowled
prude84615973pr__ude
pruned93413113pr_uned
pseud867043pse_u_d
purebred1344253purebred
pureed95017803pure__ed
pursued10388133pursued
purveyed1743353purveyed
queued16336943que_ued
raved94931433_rav_ed
reamed94326123_reamed
reaped94122453_reaped
reared75930013_reared
reaved104523923_reaved
rebred95816353_rebred
rebuked14438343_rebuked
recked134821803_recked
recused104714423_recused
redded94019543_redded
reded74829113_re_ded
reduced11610323_reduced
redyed114611233_redyed
reed55549623_re__ed
reeded84022563_reeded
reefed103816583_reefed
reeked113717643_reeked
reeled74725533_reeled
reeved104118713_reeved
refed93921923_re_fed
refeed104717623_refeed
reffed134712513_reffed
refuel93912623_refuel
refuged125410873_refuged
refund104810303_refund
refused115114443_refused
refuted114313803_refuted
reglued936333_reglued
reined74425523_reined
reived104518133_reived
relied74926233_relied
relumed1069813_relumed
rended84524103_rended
rented74426593_rented
repled93319773_repled
repped114616723_repped
reputed104613483_reputed
rescued10410043_rescued
reseed74823293_reseed
rested74430783_rested
resumed10310623_resumed
retied75924983_retied
retted74826313_retted
retuned86613973_retuned
reused75419563_reused
revalued1237023_revalued
revel84423163_rev_el
reveled113917753_reveled
revenued1237223_revenued
revered112819333_revered
revet84938843_rev_et
review1238693_review
reviled114417923_reviled
revised113815483_revised
revived144211653_revived
revoked154410523_revoked
revoted114314153_revoted
revulsed1235443_revulsed
rewed95425453_re_wed
rived94825613_riv_ed
rogued84711473_rogued
roved95323553_rov_ed
rued55729793_r__ued
segued838513_segued
served104616813serv_ed
sieved104611443siev_ed
treaded95014283treaded
treated83618703treated
trebled1038483trebled
treed65626733tre__ed
trekked1134343trekked
trended94011763trended
tressed83714253tressed
trevet94818913trev_et
trued65117693tr__ued
upreared1137073upreared
wreaked15369023wreaked
wrecked17418333wrecked
wrested113410933wrested

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273616.92319359.7
3Display Results3613610.1232935.0
 (SQL Overall)1786913617.20224811.3
 
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.