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

437 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
prepay1331031(None) 
prepays1437481prepays
preppy1235521preppy
repay104818451_repay
arepa75615562arepa_
arepas85515702arepas
crepey135110932crepey
crepy124812702crep_y
peppy114310362p_eppy
pray96331532pr__ay
prebuy1357422prebuy
predry1237872predry
prefab1336242prefab
prelacy1437582prelacy
prelaw1139102prelaw
preman104117452preman
prep86427672prep__
prepack1757642prepack
prepaid12310132prepaid
prepare111913622prepare
prepave14228872prepave
preplan1149952preplan
preps96220692prep_s
presa74319042presa_
pretax152310192pretax
pretty11510872pretty
prewar114712582prewar
prexy174611582pre_xy
prey96228482pre__y
relay84424672_relay
repays113813972_repays
replay113412922_replay
reply104015852_reply
resay85320542_resay
trepan82511672trepan
area45843393are_a_
areae55229743are_ae
areal55928733are_al
areas55935773are_as
areaway1335913areaway
areca75618633areca_
arecas84817443arecas
arena55323813arena_
arenas65021993arenas
array86317143ar_ray
belay105021523_belay
bray95232903br__ay
bread85523113bre_ad
bready124511183bready
break115319403bre_ak
bream95121813bre_am
breezy20295853breezy
copay126516313_copay
crappy15446803crappy
creak115418433cre_ak
creaky154911553creaky
cream95721353cre_am
creamy134811363creamy
creasy114612303creasy
credal9311673credal
creepy13418803creepy
crepe95520723crep_e
creped114115703creped
crepes105419343crepes
crepon1039943crepon
crept95125893crep_t
cressy11439113cressy
daresay1135433daresay
decay114718483_decay
deejay1734523deejay
deeply1257013deeply
delay94820633_delay
deray95024183_deray
drapey125010583drapey
dray85428093dr__ay
dread74419023dre_ad
dream85120393dre_am
dreamy12509993dreamy
drear65016903dre_ar
dreary104611673dreary
drecky16486333drecky
dreggy12364633dreggy
dressy10518143dressy
drippy14445653drippy
dropsy12497473dropsy
firepan1236983firepan
forebay1538133forebay
forepaw1595613forepaw
foreplay1645673foreplay
fray105428903fr__ay
freak125115243fre_ak
freaky16439233freaky
freely12310963freely
freeway1635603freeway
frena85915273frena_
frenzy2135883frenzy
fretty1249223fretty
frypan1434543frypan
grapey126012303grapey
grapy115416433grap_y
gray85329893gr__ay
greasy10419463greasy
great66034243gre_at
greedy11518853greedy
greeny104811453greeny
gremmy1454473gremmy
grey85624043gre__y
greyly13316543greyly
gripey124111203gripey
grippy14447763grippy
gripy115115253grip_y
heapy135914983_heapy
leeway1255883leeway
oread64619603ore_ad
orfray1234393orfray
overpay15228263overpay
paean77222723pae_an
paesan85114093paesan
palpal104112053palpal
pampa114913423pampa_
pampas124913993pampas
papa85827143p_apa_
papacy1547493p_apacy
papal95820673p_apal
papas94927493p_apas
papaw125112493p_apaw
papaya1337503p_apaya
papery134812743papery
pappy114713803p_appy
parkway1934553parkway
parlay113713993parlay
partway1535923partway
pawpaw1653503pawpaw
pay88461183___pay
payday1536613payday
pea56657243p_e_a_
peag75431343p_e_ag
peak106535203p_e_ak
peaky145718153p_eaky
peal68648103p_e_al
pean66147173p_e_an
pear69745233p_e_ar
peas65755063p_e_as
peat65967933p_e_at
peaty105725693p_eaty
peavy135014843p_eavy
pecan91919033p_ecan
pecky165515093p_ecky
pedal86022503p_edal
peep85833693peep__
peeped113915393peeped
peeper103614803peeper
peeps95822363peep_s
peepul1035783peepul
peery105719443p_eery
pekan111613973p_ekan
penal75228373p_enal
penny105119453p_enny
peony105717563p_eony
pep76447083p_ep__
pepla9312863p_epla
pepo87622153p_ep_o
pepos96620083p_epos
peps85134513p_ep_s
perdy115417333p_erdy
perea75026443perea_
pereia85217983pereia_
perky145319483p_erky
peroxy1838253peroxy
perp89029893perp__
perps95521483perp_s
perry105222713p_erry
pertly115312553pertly
pesky145911563p_esky
pesty106421713p_esty
petal76526893p_etal
petty105320293p_etty
phreak1536153phre_ak
phrensy1533623phrensy
pieta75421753pieta_
pietas84516503pietas
piety105817303pie_ty
pimply15329213pimply
pipal95118353p_ipal
pipy115421513p_ip_y
play95928983p__lay
plea66830603ple_a_
plead85818463ple_ad
pleas75627033ple_as
pleat74734473ple_at
pleiad947833pleiad
plena75816393plena_
plenary1237543plenary
plenty11311413plenty
plexal1536843plexal
poesy105014063poe_sy
poetry1139383poetry
popery134511703popery
poppa8409893poppa_
poppas93710713poppas
poppy114813193p_oppy
popsy125713403p_opsy
portray1237483portray
praam94815613pr_aam
pram85733493pr__am
prao66229023pr__ao
prat65952043pr__at
prau66529473pr__au
prays105022433pr__ays
preach133613923preach
preachy17307313preachy
preact103220393preact
preamp1238993preamp
preanal9310713preanal
preapply1443303preapply
prearm104512353prearm
prebade12310283prebade
prebake1539093prebake
prebid113512843prebid
prebuys1444393prebuys
precast11314853precast
precava1445093precava
precis103416703precis
precut102016533precut
predate10616893predate
predawn1335353predawn
predial103815413predial
pree67044733pre__e
preed85128123pre_ed
preen75925053pre_en
preens85020113preens
prees75937173pre_es
prefabs1435163prefabs
preface14510923preface
prefade1339013prefade
prefer113813203prefer
prefix18356853prefix
pregame1239553pregame
preheat12413893preheat
prelate9519693prelate
prelim10311423prelim
preload1049813preload
premade12311443premade
premeal11310523premeal
premed114617763premed
premen105017803premen
premie103617993premie
premix173710333premix
prename11412643prename
preop94715873pre_op
preops104911943preops
preoral9312673preoral
prepacks1836583prepacks
prepared132210873prepared
preparer12169643preparer
prepares122014163prepares
prepaste12139083prepaste
prepaved16177233prepaved
prepaves15189193prepaves
prepaying1747973prepaying
prepill1147583prepill
preplace1488983preplace
preplans1249613preplans
preplant12712913preplant
prepped11329903prepped
preppie1058093preppie
preppily1444593preppily
prepreg12165963prepreg
prepuce1337833prepuce
prepupa1064023prepupa
prepupae1144643prepupae
prepupal1164263prepupal
prepupas1144133prepupas
prerace11414123prerace
presage10312293presage
presale9416353presale
prese75228383pre_se
preset84430983preset
presoak1348453presoak
press75425953pre_ss
prest75736353pre_st
presto84216203presto
prests84021263prests
pretape113511623pretape
pretor8315753pretor
prevail1238243prevail
prevue1179163prevue
prewarm14479613prewarm
prewarn124410153prewarn
prewash1535213prewash
prewrap14104973prewrap
prex135722973pre__x
prexes154915953prexes
preyed125313203preyed
preyer114413733preyer
preys105717783pre_ys
prez156126313pre__z
prezes173614693prezes
priapi1037923priapi
pricey134412633pricey
pricky174210343pricky
pricy124814563pr_icy
prima95019343prima_
primacy1635603primacy
primal104014623primal
primary1437703primary
primas104418103primas
primly13439623primly
priory114110263priory
prissy11347853prissy
privacy1744233privacy
privy13439833pr_ivy
proa66229963pr_oa_
proas75028803pr_oas
prolan8414693prolan
prop85932813prop__
propane112716153propane
propel103714063propel
proper104319953proper
propman1339063propman
props95726883prop_s
propyl13358183propyl
prosy106319253pr_osy
prowar114110943prowar
proxy175011013pr_oxy
pruta7314243pruta_
prutah1136583prutah
pry85728053pr___y
pulpal10408453pulpal
pulpy124612363pulp_y
pupa85422813p_upa_
pupae96515643p_upae
pupal97616873p_upal
pupas95219283p_upas
puppy114912413p_uppy
purely114013633pure_ly
purply13369053purply
ray66361993_r__ay
read55942533_re_ad
ready94821503_ready
real45750293_re_al
ream65841613_re_am
reap65934743_re_ap
reaps75626193_reaps
rear45644553_re_ar
rebar75420193_rebar
rebuy104714683_rebuy
recap95718023_recap
redan66125013_redan
redbay1238333_redbay
redly94217203_redly
redry94314363_redry
reedy910020293_reedy
reefy114217703_reefy
reeky125416263_reeky
refly113914563_refly
refry114412463_refry
regal65023793_regal
rehab10312443_rehab
reify114814973_reify
rekey124014733_rekey
relax124817803_relax
relays94316753_relays
rely75428953_re_ly
reman75730153_reman
remap95418103_remap
renal55929503_renal
rep55847803_rep__
repack142412163_repack
repaid94716323_repaid
repair84011463_repair
repand95316063_repand
repark123511713_repark
repass84114703_repass
repast83520633_repast
repave114813873_repave
repeal84718283_repeal
repeat85127213_repeat
repeg84015053_repeg
repel74921403_repel
repin75324703_repin
replan83215823_replan
replays12399763_replays
repo66027543_rep_o
repos74725793_repos
repot75132623_repot
repp85418743_rep_p
repps95114343_repps
repro75315913_repro
reps65937953_rep_s
reran57329103_reran
resat55139683_resat
resaw84117253_resaw
resays93714153_resays
respray1236503_respray
retag63618413_retag
retax124517973_retax
retry84718083_retry
rewan85623663_rewan
rewax155713923_rewax
ropey106021873_ropey
ropy96323413_rop_y
seepy104717973seep_y
sepal77723003_sepal
sepoy10314303_sepoy
spay96631663__spay
spray106720063spr__ay
spread9312533spre_ad
tepa66021683_tepa_
tepal76319583_tepal
tepas76521683_tepas
tepoy10312163_tepoy
trapan82412973trapan
tray77632593tr__ay
tread64821703tre_ad
treat56240353tre_at
treaty94414353treaty
trebly1138973trebly
trefah1235093trefah
trendy10469603trendy
trepang10257293trepang
trepans92311593trepans
trepid9310083trepid
tressy9448553tressy
trey77228793tre__y
triply114211023triply
trippy13457803trippy
trophy1438283trophy
uprear8168793upre_ar
urea46528063ure_a_
ureal56722683ure_al
ureas55826013ure_as
veejay1933703veejay
virelay1335943virelay
weepy134212593weep_y
wireway1646043wireway
wreak125513273wre_ak

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127164374.92322895.8
3Display Results4374370.1233552.8
 (SQL Overall)1786914375.42232956.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.