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

165 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
percept13311252(None) 
percent113520601percent
percepts14247641percepts
precept133112511precept
except1797652_except
percents122713372percents
perfect141010832perfect
periapt11313412periapt
perpent112318812perpent
pertest9317042pertest
pervert12315582pervert
precent113520262precent
precepts14268892precepts
recept103319082re_cept
tercet83624912terce_t
accept123210643_accept
aeriest73924053aeriest
aperient10715153aperient
bereft114317303ber_eft
beret74946363ber_e_t
bewept13410323be_wept
cermet10321153cerme_t
concept133314443concept
crept95125893_cr_ept
deceit93018213de_ceit
decent94023703de_cent
decrepit1345883decrepit
decrypt1545703decrypt
descent102616293descent
discept12310623discept
eeriest73620673eeriest
erect74129333_er_ect
erupt74220063_er_upt
excepts1885203_excepts
excerpt1845943_excerpt
ferment12315573ferment
ferret93021173ferre_t
fervent13310063fervent
fiercest13216143fiercest
forceps14466983forceps
gerent73223103ger_ent
hereat93527413her_eat
incept102712763_incept
intercept13410973intercept
mercapto1443313mercapto
mercer105214203merce_r
mercers114412773mercers
mercery14397623mercery
merces105720743merce_s
merest84725113mer_est
opercele1244593opercele
parapet11317643parapet
parcel103915473parce_l
parcels113712663parcels
parent83230423par_ent
parget94529393parge_t
peace95026083peace__
peaced115818913peace_d
peaces106324083peace_s
peacoat11412913peacoat
peartest10311303peartest
peccant13311733peccant
peep85833693pe__ep_
peeps95822363pe__eps
pellet83326553pelle_t
pelmet103419243pelme_t
pence94924453pence__
pencel103812923pence_l
pencels113610063pencels
pendent10314723pendent
percale11314093percale
perceive1546973perceive
percental1348673percental
perception1688613perception
perceptive1946803perceptive
perceptual1653613perceptual
perch124518833perc__h
perched154713243perched
percher143313423percher
perchers153611523perchers
perches143717953perches
percoid12312323percoid
percuss1137163percuss
pere66450263per_e__
perea75026443per_e_a
pereia85217983per_eia
pereon83517453per_eon
peres76246643per_e_s
perfecta15115203perfecta
perfecto15105743perfecto
perfects15107353perfects
perhaps1446123perhaps
periapts1237273periapts
pericope1447783pericope
peridot10514243peridot
peripety1546193peripety
perked134617693perke_d
perkiest143313243perkiest
permeant12310913permeant
permeate12311613permeate
permed115217353perme_d
permit10321683per_mit
perp89029893per__p_
perpend12259353perpend
perpents122312043perpents
perps95521483per__ps
persalt9315413persalt
perse75429523perse__
perses85428063perse_s
persist9315853persist
perspex1834183perspex
pert66759323per___t
perter84422283perte_r
perverts1337533perverts
pierce104010393pierce__
pierced12347593pierce_d
piercer11337773pierce_r
piercers12316723piercers
pierces113411193pierce_s
placet103923673place_t
porrect1159743porrect
portent93619643portent
precast11314853precast
precede1239653precede
precents123015043precents
preceptor1547323preceptor
precess11310863precess
precipe133012123precipe
precut102016533prec_ut
preempt1337723preempt
prefect141011073prefect
preheat12413893preheat
prelect111013833prelect
premeet11615153premeet
prep86427673p_r_ep_
preps96220693p_r_eps
present94022733present
preset84430983prese_t
prest75736353p_r_est
pretest9517633pretest
pretext1639663pretext
prevent124016553prevent
priest84125423p_riest
prompt12313013p_rompt
purest84021933pur_est
reaccept1465123reaccept
receipt1159253re_ceipt
recent83630853re_cent
recepts113010273re_cepts
rerent63832453rer_ent
secret8325063secre_t
serest64831613ser_est
serpent92916283serpent
terce75721843terce__
tercel83612993terce_l
tercelet1049883tercelet
tercels94110363tercels
terces83921413terce_s
tercets93512443tercets
terret63425623terre_t
tersest71713993tersest
veriest103719133veriest
verset94327323verse_t
vervet124619063verve_t
wergelt1138583wergelt

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 Limit1340271656.53320515.4
3Display Results1651650.0463587.0
 (SQL Overall)1786911656.98525582.1
 
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.