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

390 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
prowest1231153(None) 
protest9317531protest
prowess1237901prowess
brawest123810482brawest
brownest1398892brownest
frowst125512072frow_st
lowest93915592_lowest
poorest9312772poorest
prest75736352pr__est
pretest9517632pretest
priest84125422pr_iest
probes104119452probes_
process11310402process
profess1237712profess
project1838452project
projet15315182proje_t
projets1639162projets
proles84627202proles_
prosect11313392prosect
proses84733472proses_
prosiest10416522prosiest
prost75434102pro__st
protect11313632protect
protests10310492protests
protist9320222protist
proudest1138942proudest
proves114322252proves_
provost1238572provost
prower114218122prowe_r
prowls115511082prowls_
prows106327012prow_s_
rawest93615062_rawest
slowest10168712slowest
aridest8316143aridest
armrest9310163armrest
arrest63722633ar_rest
artiest73121993artiest
blowiest1337923blowiest
bravest124211753bravest
broadest1138573broadest
bromes104719763bromes_
broses86524403broses_
browbeat1544883browbeat
browed125216393browe_d
browless1346653browless
browniest14207123browniest
browns116415633browns_
brows105425983brow_s_
browse115713853brow_se
browsed134511233browsed
browser124911143browser
browses124712693browses
closest94312533closest
coolest9318643coolest
cowiest123614673_cowiest
coyest11316053_coyest
crest74632693cr__est
crones84729243crones_
crookest1436683crookest
crores86121163crores_
crossest1012012123crossest
crowds124910763crowds_
crowed124717303crowe_d
crower114117563crowe_r
crowers124614903crowers
crowfeet1645563crowfeet
crownet123714113crownet
crownets13407673crownets
crowns115615113crowns_
crows105727313crow_s_
crozes174417663crozes_
crudest104510333crudest
doest65829523_do_est
drest65530343dr__est
driest74722753dr_iest
drollest937353drollest
drones75023433drones_
droves105116673droves_
drowns105612333drowns_
drowse105010553drow_se
drowsed12448743drowsed
drowses114610233drowses
drowsiest1334993drowsiest
drowsy13487903drow_sy
dryest104811123dr_yest
erodent8313823erodent
erodes74819883erodes_
eroses65327053eroses_
fewest12311663_fewest
forest94926743_forest
forwent13310533forwent
freest95318283fr_eest
froes86126693fro_es_
frost84727833fro__st
frowns126011393frowns_
frows116623103frow_s_
frowsiest1535063frowsiest
frowsts13426103frow_sts
frowsty16464983frow_sty
frowsy15498273frow_sy
frowziest2443483frowziest
gooiest82813883gooiest
goriest82218743goriest
gravest114011633gravest
grayest11489363grayest
greyest11348343greyest
grodiest10310553grodiest
gropes95220403gropes_
grossest93810093grossest
groves104318103groves_
grower104614933growe_r
growers113612723growers
growliest1335583growliest
growls104711113growls_
grows95523923grow_s_
honest94822423_honest
howes114730263_howes_
iratest7312483iratest
irones64724013irones_
ironist7314843ironist
krewes1337923krewes_
loosest75811563loosest
lowes85732463_lowes_
modest93818453_modest
molest85022743_molest
narrowest1244283narrowest
newest9314213_newest
orbiest9312413orbiest
owes75137103__owes_
paciest112917803paciest
palest83926223p_alest
paliest93021603paliest
parodist11412763parodist
paroles95025883paroles_
peones83821043peones_
perkiest143313243perkiest
pertest9317043pertest
pest65555293p___est
phones114121213phones_
phoniest132811533phoniest
phoresy1534653phoresy
piniest93121133piniest
pinkest132812623pinkest
piolet83225643piole_t
piolets93513193piolets
pipiest113114493pipiest
plowed124213203plowe_d
plower114315063plowe_r
plowers123812243plowers
plows105419903plow_s_
podesta1036763p_odesta
poesy105014063p_o_esy
poet65552903p_o_e_t
poets76024443p_o_ets
pokes116133013p_okes_
pokiest133314913pokiest
poles75351003p_oles_
pomes94833933p_omes_
ponent82821593p_onent
pones74547043p_ones_
pooves113914713pooves_
popes95933813p_opes_
pores75849033p_ores_
porkiest143513713porkiest
porniest103214313porniest
porrect1159743porrect
portent93619643portent
poses74642763p_oses_
poshest12312423poshest
posset84923253p_osset
post67953363p_o__st
potent84223353p_otent
power105325953p_owe_r
powers113822323p_owers
pows95537663p_ow_s_
poxes145325723p_oxes_
poxiest163412253poxiest
prases84429023prases_
prates84633163prates_
prawns11509023prawns_
praxes156215183praxes_
precast11314853precast
precent113520263precent
precept133112513precept
precess11310863precess
prees75937173pr_ees_
prefect141011073prefect
preheat12413893preheat
prelect111013833prelect
premeet11615153premeet
presa74319043pr__esa
prese75228383pr__ese
present94022733present
preset84430983pr__eset
presets94216423presets
press75425953pr__ess
presto84216203pr__esto
prests84021263pr__ests
pretests10310013pretests
pretext1639663pretext
prevent124016553prevent
prewash1535213prewash
prexes154915953prexes_
prezes173614693prezes_
prices104524543prices_
priciest122112903priciest
prides94324183prides_
pries74339533pr_ies_
priests93810863pr_iests
primes104225263primes_
primmest14226693primmest
prioress1035393prioress
prises84133173prises_
privet113821343prive_t
privets122910053privets
priviest132310313priviest
prizes173819813prizes_
proas75028803pro_as_
probe94320813probe__
probed114114823probe_d
prober104516073probe_r
probers113514583probers
probit103218353pro_bit
probits112712573probits
proceed12310553proceed
prods85523553pro_ds_
product1279233product
proem94818273pro_e_m
proems104711163pro_ems
proette9312363pro_ette
profit113016273pro_fit
profits122911243profits
profs105120893pro_fs_
profuse1237153profuse
progeny1389463progeny
progestin1248423progestin
progress1137023progress
progs86624153pro_gs_
projects1936413projects
prole74527793prole__
proleg94612113prole_g
prolegs10379993prolegs
promise113415843promise
promos105116423promos_
prompt12313013pro_mpt
promptest1546063promptest
prompts1337473prompts
proms95426413pro_ms_
prone75332623prone__
pronely12310253pronely
prongs94314483prongs_
proofs114511683proofs_
propel103714063prope_l
propels113412843propels
propend123311273propend
propene112716043propene
propense122410103propense
proper104319953prope_r
properest1349663properest
propers113619033propers
property1547073property
prophesy1844453prophesy
prophet14316033prophet
prophets1539503prophets
propjet1839913propjet
propjets1935493propjets
propose112714843propose
props95726883pro_ps_
pros65742783pro__s_
prosaist10611583prosaist
prose75835123pro__se
prosects1239473prosects
prosed94921093prose_d
proser84223463prose_r
prosers94219643prosers
prosit85124593pro_sit
proso77222413pro__so
prosos85718553prosos_
prospect1447893prospect
pross76529403pro__ss
prosses94019513prosses
prosy106319253pro__sy
protea82214763prote_a
protean92412193protean
proteas92015123proteas
protease10209893protease
protects1239743protects
protege1059153protege
protei82615313prote_i
proteid103513673proteid
protein92414733protein
protend104012793protend
proteose10229413proteose
protested12159113protested
protester111510483protester
protestor11178493protestor
proteus92511593proteus
protists10313363protists
prove104823193prove__
proved125016033prove_d
proven114314773prove_n
prover113819723prove_r
proverb14378213proverb
provers123817793provers
proviso1237313proviso
provosts1336083provosts
prow97030383prow___
prowar114110943prow_ar
prowesses1437193prowesses
prowl105615123prow__l
prowled13309913prowled
prowler123310013prowler
prowlers13328933prowlers
proxies163014933proxies_
prudent10310433prudent
prudes94215443prudes_
prunes83419063prunes_
ptoses83514673ptoses_
puniest92918093puniest
punkest132611693punkest
purest84021933p_urest
purplest12249133purplest
pursiest102812123pursiest
purtiest102414113purtiest
pyoses114314303pyoses_
pyrones123113303pyrones_
pyropes142210193pyropes_
rarest65725483_rarest
reest54938093_r_eest
renest64529713_renest
rest46459843_r__est
retest64028453_retest
revest94623603_revest
rewet85135153_rewe_t
rewets94617213_rewets
rifest93114583_rifest
ripest84317943_ripest
roast56230143_ro_ast
robes75133303_robes_
robust8310433_robust
rodent7519243_rodent
rodes614039083_rodes_
roes45954143_ro_es_
roles56747983_roles_
roost55730933_ro_ost
ropes75940063_ropes_
ropiest93317773_ropiest
roses56445773_roses_
roset55945243_rose_t
rosets65819953_rosets
rosiest73919213_rosiest
rotes56143903_rotes_
roues56039353_roues_
roust55532063_ro_ust
roves84834483_roves_
rowdiest12259213_rowdiest
rowed94034323_rowe_d
rowel84721413_rowe_l
rowels94515453_rowels
rowen84921153_rowe_n
rowens94515303_rowens
rower85430493_rowe_r
rowers94924573_rowers
rows75941753_row_s_
rudest74016313_rudest
showiest1438783showiest
snowiest1138143snowiest
soonest7415593soonest
sorest65028003_sorest
spriest92718643spr_iest
sprucest12295783sprucest
spryest12247813spr_yest
tritest7315273tritest
trokes104019263trokes_
trones65629283trones_
tropes84824353tropes_
troves94719113troves_
trowed104714653trowe_d
trowel94211463trowe_l
trowels10358363trowels
trows88826183trow_s_
truest64816193tr_uest
vrows116115263vrow_s_
west75748083___west
wrest84925433wr__est
wriest94419713wr_iest
wrongest1236733wrongest
wryest12429113wr_yest
yowes114926373_yowes_
zooiest16199923zooiest

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.393454684.5
2DLD Change Limit1340273907.14018771.3
3Display Results3903900.1402785.7
 (SQL Overall)1786913907.67323288.3
 
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.