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

176 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
properer125920(None) 
pamperer14228332pamperer
paperer113111902p_aperer
pepperer1145272pepperer
preparer12169642preparer
procurer1235832procurer
profferer1742932profferer
propeller1346622propeller
propene112716042propene_
propenes122816512propenes
proper104319952prop__er
properest1349662properest
properly1546452properly
propers113619032proper_s
property1547072property
proposer121810632proposer
prospered1446972prospered
borderer1168103borderer
broiderer1244353broiderer
brokered1536083brokered
caperer113013403_caperer
coherer122912783_coherer
coopered133310933coopered
coverer123113523_coverer
cropper133312963crop_per
dapperer1335763dapperer
dropper12329873drop_per
flowerer1435453flowerer
groper94517253grop__er
gropers104813853groper_s
groveler12305843groveler
hamperer15379093hamperer
hoverer13319823_hoverer
kipperer16294723kipperer
opener83910993__opener
orderer8127943or_derer
orometer10310703orometer
palterer102411273palterer
pampered15229223pampered
pamperers15236863pamperers
panderer112210913panderer
papered122513163p_apered
paperers122410453p_aperers
patterer103112173patterer
paupered13216933paupered
peopler1138073peop_ler
peppered1236123peppered
pepperers1244893pepperers
pesterer102412703pesterer
pewterer13256313pewterer
pilferer1344923pilferer
pioneer936893pione_er
ponderer112410193ponderer
poorer82613993p_o_orer
poperies12316793p_operies
popery134511703p_oper_y
popeyed1535703p_opeyed
popover1495843p_opover
popper93615963p_op_per
portered112311533portered
potterer102310263potterer
pourer84516043p_o_urer
powderer14245593powderer
powered132911643p_owered
preener93114833pr_eener
prefer113813203pr__efer
preferrer1443893preferrer
premerger1444903premerger
prepare111913623prepare_
prepared132210863prepared
preparers13197673preparers
prepares122014163prepares
preppier1156643preppier
prepreg12165963prep_reg
preserver14127013preserver
preyer114413733pr__eyer
prisere9310943prisere_
priseres10310823priseres
prober104516073pro__ber
probers113514583prober_s
proceed12310543proce_ed
proceeder1444163proceeder
processer1346893processer
procure1138573procure_
procured1336603procured
procurers1345033procurers
procures1239213procures
prodder1147953pro_dder
producer1355843producer
profaner13197943profaner
proffer15126933pro_ffer
proffered1843433proffered
profferers1842423profferers
profiler13287643profiler
profiter132710203profiter
progeria1147943progeria
progger11319373pro_gger
promiser122510673promiser
promoter12311453promoter
prompter1437983prompter
proofer12149103pro_ofer
propane112716153propane_
propanes122415823propanes
propel103714063prop__el
propelled1456903propelled
propellers1455203propellers
propellor1344543propellor
propels113412843prope_ls
propend123311273prope_nd
propended1546163propended
propends13249173propends
propenol1246473propenol
propense122410103propense
propenyl1544583propenyl
properdin1446273properdin
properness1445923properness
propertied15137253propertied
properties141411883properties
prophesier17114333prophesier
prophet14316033prop_het
propine113020213propine_
propined133111503propined
propines122618933propines
propjet1839913prop_jet
propmen1338763prop_men
propone112716303propone_
proponed132412033proponed
propones122516963propones
propose112714843propose_
proposed132011073proposed
proposers13228523proposers
proposes122515973proposes
propped113311953prop_ped
propretor1345533propretor
propria1149933prop_ria
proser84223463pro__ser
prosers94219643proser_s
prosier93817483pro_sier
prosper114012193pro_sper
prospers123012263prosper_s
protecter13179103protecter
protege1059153protege_
protegee1156953protegee
proteges1149923proteges
protester111510483protester
prouder10310383pro_uder
provender1544893provender
prover113819723pro__ver
proverb14378213prover_b
proverbed1743813proverbed
proverbs15315583proverbs
provers123817793prover_s
provider1436703provider
provoker1784913provoker
prower114218123pro__wer
prowler123310013pro_wler
puckerer1645793puckerer
putterer10209913putterer
pyrometer1648883pyrometer
reverer103815833_reverer
ripener937903_ripener
roarer63914333_ro_arer
rogered939553_rogered
roper75431913_rop__er
roperies10315763_roperies
ropers84325903_roper_s
ropery114313873_roper_y
ropier84118803_rop_ier
showerer1436163showerer
simperer1237173simperer
soberer93110353_soberer
sorcerer1036433sorcerer
tamperer12248893tamperer
taperer92511793_taperer
temperer12227723temperer
troweler11106063troweler

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.1561145455.1
2DLD Change Limit1461621767.68619016.7
3Display Results1761760.0802200.0
 (SQL Overall)1786911767.92222556.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.