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

255 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
proverb1437821(None) 
preverb14317061preverb
prover113819721prover_
proverbs15315581proverbs
provers123817791provers
drover104614592drover_
drovers115212642drovers
plover115312612plover_
plovers123611832plovers
preverbs15295302preverbs
prober104516072prober_
probers113514582probers
proper104319952proper_
propers113619032propers
proser84223462proser_
prosers94219642prosers
prove104823192prove__
proved125016032prove_d
proven114314772prove_n
proverbed1743812proverbed
proves114322252prove_s
prower114218122prower_
reverb113912572_reverb
rover85527372_rover_
rovers95423522_rovers
trover95014662trover_
trovers103713322trovers
adverb12265413_adverb
approver15105303approver_
approvers16104913approvers
braver114719043braver_
bravers124715523bravers
bravery15428133bravery
broker124314243broker_
brokers133111913brokers
clover114617123clover_
clovers125114663clovers
clovery15407403clovery
cover105430773_cover_
covers114627963_covers
covert114925503_covert
craver114618473craver_
cravers124416563cravers
crower114117563crower_
crowers124614903crowers
crozer175112843crozer_
crozers184111083crozers
driver104714493driver_
drivers114412793drivers
droner74717673droner_
droners84114383droners
drosera836203drosera
drove95518063drove__
droved114611643drove_d
droves105116673drove_s
glover104513533glover_
glovers114310883glovers
govern1036823_govern
graver105018593graver_
gravers114515273gravers
grocer94212143grocer_
grocers103511253grocers
grocery13336763grocery
groover11358543groover_
groovers12337123groovers
groper94517253groper_
gropers104813853gropers
grove95219333grove__
groved114413703grove_d
grovel104310543grove_l
grovels11427813grovels
groves104318103grove_s
grower104614933grower_
growers113612723growers
hoover124314433hoover_
hoovers134312713hoovers
hover115524133_hover_
hovers124320253_hovers
improver1545243improver_
improvers1645043improvers
ironer64216453ironer_
ironers74813553ironers
kroner104612573kroner_
lover85526453_lover_
lovers94223433_lovers
mover104220863_mover_
movers115117193_movers
over77227343__over_
overs85224793__overs
overt85630723__overt
paver104225833p_aver_
pavers115021823p_avers
pervert12315583pervert
plower114315063plower_
plowers123812243plowers
poker115122883p_oker_
pokers124617923p_okers
poler74431793p_oler_
polers84225643p_olers
pooler83819843pooler_
poolers94217423poolers
poorer82613993poorer_
poove104514303poove__
pooves113914713poove_s
popery134511703p_opery
popover1495843popover_
popovers1595663popovers
porker124917543porker_
porkers134314933porkers
porter84224413porter_
porters93722703porters
poser75128773p_oser_
posers84223973p_osers
potherb14358683potherb
poverty1536433p_overty
power105325953p_ower_
powers113822323p_owers
prater84825353prater_
praters94921653praters
prayer114815293prayer_
prayers124212853prayers
preaver121011613preaver_
preavers13910263preavers
prefer113813203prefer_
prefers123713333prefers
preterm11310163preterm
prevent124016553prevent
preverbal1643883preverbal
preyer114413733preyer_
preyers124412363preyers
pricer103918293pricer_
pricers113915063pricers
prier75027763pr_ier_
priers84521193pr_iers
primer105118683primer_
primero11368923primero
primers114215673primers
prisere9310943prisere
privet113821343prive_t
privets122910053privets
privier122910453privier_
prizer174714883prizer_
prizers183911843prizers
probe94320813probe__
probed114114823probe_d
probes104119453probe_s
procarp1346823procarp
proceed12310553proceed
process11310403process
procure1138573procure
prodder1147953prodder_
prodders1237463prodders
proem94818273pro_e_m
proems104711163pro_ems
profess1237713profess
proffer15126933proffer_
proffers16126593proffers
progeny1389463progeny
progeria1147943progeria
progger11319373progger_
proggers12258163proggers
project1838453project
projet15315183proje_t
projets1639163projets
prole74527793prole__
proleg94612113prole_g
prolegs10379993prolegs
proles84627203prole_s
prone75332623prone__
pronely12310253pronely
proofer12149103proofer_
proofers13118363proofers
propel103714063prope_l
propels113412843propels
propend123311273propend
propene112716043propene
properer1259203properer
properly1546463properly
property1547073property
prose75835123prose__
prosect11313393prosect
prosed94921093prose_d
proses84733473prose_s
prosier93817483prosier_
prosper114012193prosper_
prospers123012263prospers
protea82214763prote_a
protean92412193protean
proteas92015123proteas
protect11313633protect
protege1059153protege
protei82615313prote_i
proteid103513673proteid
protein92414733protein
protend104012793protend
protest9317533protest
proteus92511593proteus
prouder10310383prouder_
provenly1646203provenly
proverbial1753213proverbial
proverbing1843783proverbing
provide1339853provide
provider1436703provider_
providers1535593providers
proving134214073proving
proviral1346493proviral
provirus1345453provirus
proviso1237313proviso
provoke1676123provoke
provoker1784913provoker_
provokers1894203provokers
provost1238573provost
prowar114110943prowar_
prowess1237903prowess
prowest12311533prowest
prowler123310013prowler_
prowlers13328933prowlers
prudery1335243prudery
pruner83413453pruner_
pruners93710723pruners
pryer104415313pr_yer_
pryers115012243pr_yers
raver85631493_raver_
ravers94628183_ravers
reprover13229203reprover_
reprovers14217773reprovers
reverbs12368863_reverbs
revere94621253_revere
revers94529633_revers
revert93529113_revert
revery124014213_revery
river85731693_river_
rivers94626543_rivers
roger64521413_roger_
rogers74517913_rogers
roper75431913_roper_
ropers84325903_ropers
ropery114313873_ropery
rosery93813283_rosery
rove75136983_rove__
roved95323553_rove_d
roven85521973_rove_n
roves84834483_rove_s
rower85430493_rower_
rowers94924573_rowers
shover124515993shover_
shovers134613003shovers
stover94115643stover_
stovers103713733stovers
trouvere1144073trouvere
trove85221923trove__
troves94719113trove_s
upriver12196933upriver_
uprivers13215563uprivers
verb96224873___verb

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.406440125.6
2DLD Change Limit1340272557.44018014.4
3Display Results2552550.0932741.9
 (SQL Overall)1786912557.93922508.0
 
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.