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

259 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
prelect11101383(None) 
praelect1247531praelect
preelect1249641preelect
prefect141011071prefect
prelects1299721prelects
elect74327032__elect
perfect141010832perfect
praefect1544772praefect
praelects1354352praelects
preact103220392pre_act
precent113520262precent
precept133112512precept
predict12315322predict
preelects1356082preelects
preerect1259272preerect
prefects1598132prefects
preheat12413892preheat
prelacy1437582prelacy
prelected1439132prelected
prelector1348092prelector
premeet11615152premeet
preselect1346982preselect
present94022732present
preset84430982prese_t
pretest9517632pretest
pretext1639662pretext
prevent124016552prevent
project1838452project
prosect11313392prosect
protect11313632protect
reelect911515632reelect
refect114319332_refect
reflect123913712_reflect
reject154116282_reject
relent64431852_relent
relet54749822_rele_t
relict83623902_relict
reluct83916112_reluct
resect84424702_resect
select82621172_select
acrolect1247423acrolect
arbelest1049503arbelest
armlet84118193armle_t
breech13348263bre_ech
brevet115717333breve_t
coerect11913353coerect
collect113314593collect
credent10313973credent
cruelest1059183cruelest
defect124816173_defect
deflect13399973deflect
deject164512843_deject
delict94320333_delict
derelict11138483derelict
deselect1147523deselect
detect94217403_detect
dialect101210263dialect
eject145016043__eject
elects83315003__elects
erect74129333__erect
eyelet9514533eyele_t
freest95318283fre_est
greet65835323gre_e_t
greyest11348343greyest
inflect1249223inflect
ireless72312243ireless
kreplech1941583kreplech
neglect1047363neglect
nonelect10410283nonelect
omelet8317073omele_t
palest83926223p_alest
palet74650803p_ale_t
pallet84232653palle_t
pandect12310953pandect
partlet92720363partle_t
peeled94119713peele_d
peeler83517383peele_r
peelers93615593peelers
pele65539553p_ele__
peles75738083p_ele_s
pellet83326553p_ellet
pelmet103419243p_elmet
pelt67651083p_el__t
percent113520603percent
percept133112523percept
perfecta15115203perfecta
perfecto15105743perfecto
perfects15107353perfects
perpent112318813perpent
pertest9317043pertest
pervert12315583pervert
piglet93420923pigle_t
piolet83225643piole_t
pleat74734473p__leat
polecat11313143p_olecat
porrect1159743porrect
praefects1642873praefects
praelected1544393praelected
preach133613923pre_ach
preacts113211363pre_acts
preallot1047033preallot
prebend12319443prebend
prebless1236823prebless
precast11314853precast
precede1239653precede
precents123015043precents
precepts14268893precepts
precess11310863precess
precheck2144153precheck
precinct1459423precinct
preclean1245893preclean
preclear1245423preclear
precut102016533pre_cut
predeath1447003predeath
prededuct1543103prededuct
predicts1339613predicts
pree67044733pre_e__
preed85128123pre_e_d
preedit10512463preedit
preelected1545783preelected
preempt1337723preempt
preen75925053pre_e_n
preenact12410183preenact
preens85020113pre_ens
preerects1345413preerects
prees75937173pre_e_s
preface14510923preface
prefer113813203prefe_r
prefers123713333prefers
preheats1339413preheats
prelate9519693prelate
prelaw1139103prel_aw
prelecting15310163prelecting
prelection141511293prelection
prelectors1447873prelectors
prelegal1145053prelegal
prelife1279943prelife
prelim10311423prel_im
prelimit1259123prelimit
prelims1139823prelims
preload1049813preload
prelocate13109523prelocate
prelude1038013prelude
prelunch1543433prelunch
premeal11310523premeal
premed114617763preme_d
premeds12389593premeds
premen105017803preme_n
premixt183510663premixt
premolt11312073premolt
prepack1757643prepack
preplace1488983preplace
preplant12712913preplant
prepuce1337833prepuce
prerace11414123prerace
prerectal1345693prerectal
preriot9316413preriot
prerock1536723prerock
prese75228383prese__
preselects1464363preselects
presell939303presell
presence122213513presence
presents103315643presents
presets94216423presets
presift12312223presift
presleep1244493presleep
preslice1258623preslice
presort95219543presort
prest75736353pr__est
preteen939873preteen
pretell938243pretell
pretence122312123pretence
pretend104011013pretend
preterit10315843preterit
preterm11310163preterm
pretests10310013pretests
pretexts1735603pretexts
pretreat10311923pretreat
prevalent14128063prevalent
prevents133012293prevents
preverb14317063preverb
prexes154915953prexe_s
preyed125313203preye_d
preyer114413733preye_r
preyers124412363preyers
prezes173614693preze_s
priest84125423pr_iest
privet113821343prive_t
product1279233product
projects1936413projects
projet15315183proje_t
prole74527793prole__
proleg94612113prole_g
prolegs10379993prolegs
proles84627203prole_s
prosects1239473prosects
prospect1447893prospect
protects1239743protects
protest9317533protest
prowest12311533prowest
prudent10310433prudent
pullet84026333pulle_t
purplest12249133purplest
purulent1047613purulent
react74634333_re_act
realest73322433_realest
rebec94416543_rebec_
rebeck14419913_rebeck
rebecs103913673_rebecs
reblent9614253_reblent
recent83630853_recent
recept103319073_recept
redact9419043_redact
reeject16349623reeject
reelects103110883reelects
reerect92915883reerect
reest54938093_re_est
refects124012743_refects
refelt94521423_refelt
reflects13288873_reflects
reflet94024233_refle_t
regent74127673_regent
reglet73724233_regle_t
reheat94423943_reheat
rejects163910693_rejects
relace83122153_relace
relend76116453_relend
relents74018503_relents
relets64025673_relets
releve95116403_releve
relic74623363_relic_
relics84517903_relics
relicts94414593_relicts
relist64628413_relist
relit55340683_rel_it
relock124713523_relock
relucts9369673_relucts
remeet86325473_remeet
remelt85123123_remelt
remet74843723_reme_t
renest64529713_renest
repeat85127213_repeat
repent84728873_repent
rerent63832453_rerent
reseat64131493_reseat
resects94115593_resects
reselect1059943reselect
resent63833623_resent
reset55051863_rese_t
respect11412033_respect
retest64028453_retest
revert93529113_revert
revest94623603_revest
revet84938843_reve_t
rewet85135153_rewe_t
selects91912143_selects
traject1637043traject
trevet94818913treve_t
trisect939733trisect

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 Limit1340272596.98619185.1
3Display Results2592590.0932784.9
 (SQL Overall)1786912597.48523873.2
 
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.