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

155 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
proverbs1531558(None) 
preverbs15295301preverbs
proverb14378211proverb_
provers123817791prover_s
drovers115212642drover_s
plovers123611832plover_s
preverb14317062preverb_
probers113514582prober_s
propers113619032proper_s
prosers94219642proser_s
prover113819722prover__
proverbed1743812proverbed
proves114322252prove__s
provirus1345452provirus
reverbs12368862_reverbs
rovers95423522_rover_s
trovers103713322trover_s
adverbs13254273_adverbs
approvers16104913approver_s
bravers124715523braver_s
brokers133111913broker_s
clovers125114663clover_s
covers114627963_cover_s
coverts124813813_coverts
cravers124416563craver_s
crowers124614903crower_s
crozers184111083crozer_s
drivers114412793driver_s
droners84114383droner_s
droseras935883droseras
drover104614593drover__
droves105116673drove__s
glovers114310883glover_s
governs1136103_governs
gravers114515273graver_s
grocers103511253grocer_s
groovers12337123groover_s
gropers104813853groper_s
grovels11427813grove_ls
groves104318103grove__s
growers113612723grower_s
hoovers134312713hoover_s
hovers124320253_hover_s
improvers1645043improver_s
ironers74813553ironer_s
lovers94223433_lover_s
movers115117193_mover_s
overs85224793__over_s
pavers115021823p_aver_s
perverts1337533perverts
plover115312613plover__
plowers123812243plower_s
pokers124617923p_oker_s
polers84225643p_oler_s
poolers94217423pooler_s
pooves113914713poove__s
popovers1595663popover_s
porkers134314933porker_s
porters93722703porter_s
posers84223973p_oser_s
potherbs15387123potherbs
poverty1536433p_overty
powers113822323p_ower_s
praters94921653prater_s
prayers124212853prayer_s
preavers13910263preaver_s
prefers123713333prefer_s
preterms1237223preterms
prevents133012293prevents
preverbal1643883preverbal
preyers124412363preyer_s
pricers113915063pricer_s
priers84521193pr_ier_s
primeros12336883primeros
primers114215673primer_s
priseres10310823priseres
privets122910053prive_ts
prizers183911843prizer_s
prober104516073prober__
probes104119453probe__s
procarps1445973procarps
proceeds1335983proceeds
process11310403proce_ss
procures1239213procures
prodders1237463prodder_s
proems104711163pro_e_ms
profess1237713profe_ss
proffers16126593proffer_s
progeria1147943progeria
progerias1248623progerias
proggers12258163progger_s
progress1137023progress
projects1936413projects
projets1639163proje_ts
prolegs10379993prole_gs
proles84627203prole__s
proofers13118363proofer_s
propels113412843prope_ls
propends13249173propends
propenes122816513propenes
proper104319953proper__
properer1259203properer
properest1349663properest
properly1546463properly
property1547073property
prosects1239473prosects
proser84223463proser__
proses84733473prose__s
prospers123012263prosper_s
proteans102811543proteans
proteas92015123prote_as
protects1239743protects
proteges1149923proteges
proteids11259953proteids
proteins102114283proteins
protends113010353protends
protests10310493protests
proteus92511593prote_us
prove104823193prove___
proved125016033prove__d
proven114314773prove__n
provenly1646203provenly
proverbial1753213proverbial
proverbing1843783proverbing
providers1535593provider_s
provides1439883provides
proviral1346493proviral
provisos1336913provisos
provokers1894203provoker_s
provokes1776603provokes
provosts1336083provosts
prower114218123prower__
prowess1237903prowe_ss
prowlers13328933prowler_s
pruners93710723pruner_s
pryers115012243pr_yer_s
ravers94628183_raver_s
reprovers14217773reprover_s
reverb113912573_reverb_
reveres103621343_reveres
revers94529633_rever_s
reverts104715043_reverts
rivers94626543_river_s
rogers74517913_roger_s
ropers84325903_roper_s
rover85527373_rover__
roves84834483_rove__s
rowers94924573_rower_s
shovers134613003shover_s
stovers103713733stover_s
trouveres1243773trouveres
trover95014663trover__
troves94719113trove__s
uprivers13215563upriver_s
verbs104614393___verbs

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621557.14020470.9
3Display Results1551550.0632460.3
 (SQL Overall)1786911557.60923484.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.