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

229 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
prefect14101107(None) 
perfect141010831perfect
praefect1544771praefect
prefects1598131prefects
prelect111013831prelect
refect114319331_refect
defect124816172_defect
perfecta15115202perfecta
perfecto15105742perfecto
perfects15107352perfects
praefects1642872praefects
praelect1247532praelect
preact103220392pre_act
precent113520262precent
precept133112512precept
predict12315322predict
preelect1249642preelect
preerect1259272preerect
preface14510922preface
prefer113813202prefe_r
prefers123713332prefers
preheat12413892preheat
prelects1299722prelects
premeet11615152premeet
present94022732present
preset84430982prese_t
pretest9517632pretest
pretext1639662pretext
prevent124016552prevent
project1838452project
prosect11313392prosect
protect11313632protect
refects124012742_refects
refelt94521422_refelt
reflect123913712_reflect
reject154116282_reject
resect84424702_resect
affect1448903_affect
artefact1345183artefact
breech13348263bre_ech
brevet115717333breve_t
briefest1335893briefest
coeffect1843933coeffect
coerect11913353coerect
confect143614273confect
credent10313973credent
defeat103817163_defeat
defects134511523_defects
deflect13399973_deflect
deject164512843_deject
detect94217403_detect
effect1437443_effect
eject145016043__eject
elect74327033__elect
erect74129333__erect
forefeet14129393forefeet
forefelt14117363forefelt
freest95318283fre_est
greet65835323gre_e_t
greyest11348343greyest
imperfect1844143imperfect
infect113413443_infect
liefest1038443liefest
pandect12310953pandect
percent113520603percent
percept133112523percept
perfectas16135073perfectas
perfected1736633perfected
perfecter1646043perfecter
perfectly1944103perfectly
perfectos16106073perfectos
perpent112318803perpent
pertest9317043pertest
pervert12315583pervert
piefort1249533piefort
porrect1159743porrect
praelects1354353praelects
preach133613923pre_ach
preacts113211363pre_acts
prebend12319443prebend
precast11314853precast
precede1239643precede
precents123015043precents
precepts14268883precepts
precess11310863precess
precheck2144153precheck
precinct1459423precinct
precut102016533pre_cut
predeath1447003predeath
prededuct1543103prededuct
predicts1339613predicts
pree67044733pre_e__
preed85128113pre_e_d
preedit10512453preedit
preelects1356083preelects
preempt1337723preempt
preen75925053pre_e_n
preenact12410183preenact
preens85020113pre_ens
preerects1345413preerects
prees75937173pre_e_s
prefab1336243pref_ab
prefabs1435163prefabs
prefaced1638423prefaced
prefacer1537983prefacer
prefaces15311063prefaces
prefade1339013prefade
prefecture1744803prefecture
prefight1746393prefight
prefile123413183prefile
prefire124012813prefire
prefix18356853pref_ix
prefocus1544743prefocus
preform1439603preform
prefund1335733prefund
preheats1339413preheats
prelacy1437583prelacy
prelected1439123prelected
prelector1348093prelector
premeal11310513premeal
premed114617753preme_d
premeds12389583premeds
premen105017803preme_n
premixt183510663premixt
premolt11312073premolt
prepack1757643prepack
prepuce1337833prepuce
prerace11414123prerace
prerectal1345693prerectal
preriot9316413preriot
prerock1536723prerock
prese75228383prese__
preselect1346983preselect
presell939293presell
presence122213513presence
presents103315643presents
presets94216423presets
presift12312223presift
presort95219533presort
prest75736353pr__est
preteen939873preteen
pretell938233pretell
pretence122312123pretence
pretend104011013pretend
preterit10315843preterit
preterm11310153preterm
pretests10310013pretests
pretexts1735603pretexts
pretreat10311923pretreat
prevents133012293prevents
preverb14317063preverb
prexes154915943prexe_s
preyed125313193preye_d
preyer114413733preye_r
preyers124412363preyers
prezes173614693preze_s
priest84125423pr_iest
privet113821343prive_t
product1279233product
profess1237713profess
profit113016273prof_it
projects1936413projects
projet15315183proje_t
prosects1239473prosects
prospect1447893prospect
protects1239743protects
protest9317533protest
prowest12311533prowest
prudent10310433prudent
react74634333_re_act
rebec94416543_rebec_
rebeck14419913_rebeck
rebecs103913673_rebecs
recent83630853_recent
recept103319073_recept
redact9419043_redact
redefect1446053redefect
reeject16349623reeject
reelect911515633reelect
reerect92915883reerect
reest54938093_re_est
reface113616353_reface
refected142311663_refected
refed93921923_refe_d
refeed104717623_refeed
refeel93913243_refeel
refel84920813_refe_l
refell94214443_refell
refels94618053_refels
refence12312233_refence
refer84822143_refe_r
refers93921083_refers
refit84230063_ref_it
reflects13288873_reflects
reflet94024233_reflet
refract121311603_refract
reft75141273_ref__t
regent74127673_regent
reheat94423943_reheat
reinfect1346483_reinfect
rejects163910693_rejects
relent64431853_relent
relet54749823_rele_t
relict83623903_relict
reluct83916113_reluct
remeet86325473_remeet
remelt85123123_remelt
remet74843723_reme_t
renest64529713_renest
repeat85127213_repeat
repent84728873_repent
rerent63832453_rerent
reseat64131493_reseat
resects94115593_resects
resent63833623_resent
reset55051863_rese_t
respect11412033_respect
retest64028453_retest
revert93529113_revert
revest94623603_revest
revet84938843_reve_t
rewet85135153_rewe_t
rifest93114583_rifest
select82621173_select
traject1637043traject
trevet94818913treve_t
trifecta1343573trifecta
trisect939733trisect
unperfect1643643unperfect

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.1561145455.1
2DLD Change Limit1340272297.70317399.3
3Display Results2292290.0763013.2
 (SQL Overall)1786912297.93522519.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.