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

162 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
perfect14101083(None) 
perfecta15115201perfecta
perfecto15105741perfecto
perfects15107351perfects
prefect141011071prefect
defect124816172de_fect
effect1437442_effect
erect74129332_er_ect
imperfect1844142imperfect
percent113520602percent
percept133112522percept
perfectas16135072perfectas
perfected1736642perfected
perfecter1646042perfecter
perfectly1944112perfectly
perfectos16106072perfectos
perpent112318812perpent
pertest9317042pertest
pervert12315582pervert
porrect1159742porrect
prefects1598132prefects
prelect111013832prelect
refect114319332re_fect
unperfect1643642unperfect
aeriest73924053aeriest
affect1448903_affect
aperient10715153aperient
befret11315963befre_t
bereft114317303ber_eft
beret74946363ber_e_t
cermet10321153cerme_t
coeffect1843933coeffect
coerect11913353coer_ect
confect143614273confect
correct11513983correct
deafest112911513deafest
defeat103817163de_feat
defects134511523de_fects
deffest14308803deffest
deflect13399973deflect
deject164512843de_ject
detect94217403de_tect
direct93817333dir_ect
eeriest73620673eeriest
effects1535283_effects
eject145016043_e_ject
elect74327033_e_lect
erects84116183_er_ects
eruct74022353_er_uct
expect1758903_expect
exsect1558503_exsect
ferment12315573ferment
ferret93021173ferre_t
fervent13310063fervent
forfeit1339203forfeit
gerent73223103ger_ent
hereat93527413her_eat
imperfects1942883imperfects
infect113413443_infect
kerfed14358233kerfe_d
merest84725113mer_est
neglect1047363neglect
pandect12310953pandect
parent83230423par_ent
parfait12312053parfait
parget94529393parge_t
parsec105914483parsec_
parsecs11429923parsecs
peartest10311303peartest
pellet83326553pelle_t
pelmet103419243pelme_t
pendent10314723pendent
percents122713373percents
percepts14247643percepts
perch124518833per__ch
pere66450263per_e__
perea75026443per_e_a
pereia85217983per_eia
pereon83517453per_eon
peres76246643per_e_s
perfecters1745433perfecters
perfectest1744813perfectest
perfecting1847513perfecting
perfection1748363perfection
perfective2047193perfective
perfidy1635273perfidy
perforce1544963perforce
perform1439283perform
perfume1446503perfume
perfumy1763933perfumy
perfuse1247663perfuse
periapt11313413periapt
peridot10514243peridot
perked134617693perke_d
perkiest143313243perkiest
permeant12310913permeant
permeate12311613permeate
permed115217353perme_d
permit10321683per_mit
perpend12259353perpend
perpents122312043perpents
persalt9315413persalt
perse75429523perse__
persecute1344883persecute
perses85428063perse_s
persist9315853persist
pert66759323per___t
perter84422283perte_r
perverts1337533perverts
pluperfect1951303pluperfect
portent93619643portent
praefect1544773praefect
preact103220393p_react
precent113520263precent
precept133112513precept
precut102016533p_r_ecut
predict12315323predict
preelect1249643preelect
preerect1259273preerect
preface14510923preface
prefer113813203prefe_r
prefers123713333prefers
preheat12413893preheat
prelects1299723prelects
premeet11615153premeet
present94022733present
preset84430983prese_t
prest75736353p_r_est
pretest9517633pretest
pretext1639663pretext
prevent124016553prevent
priest84125423p_riest
project1838453project
prosect11313393prosect
protect11313633protect
purest84021933pur_est
redefect1446053redefect
reeject16349623reeject
reelect911515633reelect
reerect92915883reerect
refects124012743re_fects
refelt94521423re_felt
reflect123913713reflect
refract121311603refract
reinfect1346483reinfect
reject154116283re_ject
rerent63832453rer_ent
resect84424703re_sect
respect11412033respect
select82621173se_lect
serest64831613ser_est
serpent92916283serpent
surfeit10310343surfeit
tercet83624913terce_t
terret63425623terre_t
tersest71713993tersest
verdict1339583verdict
veriest103719133veriest
verset94327323verse_t
vervet124619063verve_t
webfeet1544593webfeet
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 Limit1340271627.12318816.1
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.59223536.7
 
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.