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

442 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
preacts11321136(None) 
preact103220391preact_
reacts83616601_reacts
abreacts1245632abreacts
bracts105617772br_acts
breasts939702breasts
erects84116182ere_cts
greats76318392grea_ts
pacts95125802p__acts
peaces106324082p_eaces
peats76140192p_ea_ts
pleats85218592plea_ts
prats76333392pr_a_ts
preach133613922preac_h
preaches153214892preaches
preachy17307312preachy
preacted132710942preacted
preamps1336612preamps
prearms11369172prearms
precast11314852precast
precasts1239452precasts
precis103416702pre_cis
precuts111710472precuts
predicts1339612predicts
preenacts1345842preenacts
prefaces15311062prefaces
prefects1598132prefects
prelects1299722prelects
prepacks1836582prepacks
presets94216422presets
prests84021262pre_sts
react74634332_react_
redacts10510942_redacts
tracts85019072tr_acts
treats64821692trea_ts
abreact11310823abreact_
acts66929863___acts
areas55935773area__s
arecas84817443are_cas
arhats9312973arha_ts
arracks1387733arracks
artefacts1443153artefacts
beasts84519723_beasts
beats76042243_bea_ts
beauts86015283_beauts
bleats85518613blea_ts
braces108427773br_aces
brachs134415753br_achs
bract96332723br_act_
brants85723053br_ants
brats75336013br_a_ts
breach134213723breac_h
breaches153714123breaches
breads95419203brea_ds
breadth1365993breadth
breadths1474463breadths
breaks124816423brea_ks
breams104815043brea_ms
breast8319633breast_
breath113916263brea_th
breaths124411183breaths
brents84717273bre_nts
brevets12519393brevets
cheats114519543chea_ts
cleats84919313clea_ts
coacts105314333_coacts
coenacts1246403coenacts
cracks144817003cr_acks
crafts115312743cr_afts
creaks124315963crea_ks
creams104715253crea_ms
creases94020963creases
create85126383crea_te
creates95225203creates
credits1039973credits
crests85218703cre_sts
crewcuts1542183crewcuts
derats74625063dera_ts
didacts1186063didacts
directs102710263dire_cts
drafts105012533dr_afts
drats66628373dr_a_ts
dreads84115023drea_ds
dreams94513983drea_ms
dreamt94615713dreamt_
drears74614253drea_rs
drecks13459203dre_cks
easts57530323__easts
eats47054873__ea_ts
ejects15409953eje_cts
elects83315003ele_cts
enacts84012973_enacts
epacts105010393_epacts
erect74129333ere_ct_
errants7410643errants
eructs83610793er_ucts
exacts15359613_exacts
facts107021893__facts
feasts95116093_feasts
feats86432753_fea_ts
fracas11311993fr_acas
fracti1139963fr_acti
fractus12146593fr_actus
frats86829673fr_a_ts
freaks134713063frea_ks
frescos1236813frescos
frets85523403fre__ts
graces94523493gr_aces
grafts105013253gr_afts
grants73722473gr_ants
greases84816713greases
great66034243grea_t_
greaves113311443greaves
greets75117423gre_ets
groats74816653groa_ts
hearts96218943_hearts
heats85838403_hea_ts
impacts13266503impacts
krafts13438853kr_afts
kraits104912203kr_aits
krauts10418513kr_auts
leasts64616413_leasts
meats75034053_mea_ts
misacts1139353misacts
neats55931903_nea_ts
operants1039483operants
oreads73915773orea_ds
orgeats838353orgea_ts
outacts9310213outacts
overacts1339653overacts
pacas96029403p__acas
paces96741113p__aces
packs135528933p__acks
pacs85842183p__ac_s
pact86648723p__act_
paeans85118263paea_ns
pageants1136693pageants
palaces114216453palaces
pants76536923p__ants
parents93418123pare_nts
parfaits1346913parfaits
parts77743373p__arts
pasts75936503p__asts
patacas11311003patacas
pats66460853p__a_ts
peace95026083p_eac_e
peaced115818913p_eaced
peach125422493p_eac_h
peaches144120053p_eaches
peachy164510843p_eachy
peacoats1247833p_eacoats
peages94321853p_eages
peags86122843p_ea_gs
peaks114825623p_ea_ks
peals75235493p_ea_ls
peans75437643p_ea_ns
peanuts936993p_eanuts
pearls84715393p_earls
pears75138613p_ea_rs
peart76440753p_eart_
peas65755063p_ea__s
peases85229473p_eases
peat65967933p_ea_t_
peaty105725693p_ea_ty
pecans101515833p_ecans
pechs125516203p_e_chs
pecks135724433p_e_cks
pecs84634103p_e_c_s
pedants10310113pedants
peewits12105873peewits
pelts76128813p_e_lts
peracid12312993peracid
peracids13310073peracids
perfects15107353perfects
periapts1237273periapts
permits11314003permits
persalts1038193persalts
pests75933273p_e_sts
pets66248333p_e__ts
pewits112810683p_ewits
phreaks1634543phrea_ks
pieces104217273pie_ces
pierces113411193pierces
places104323703p_laces
placets113911223p_lacets
placks144414153p_lacks
plaits83816473p_laits
plants84921803p_lants
plats75531373p_la_ts
playacts1543813playacts
pleach134211243pleac_h
pleaches153210433pleaches
pleads94613953plea_ds
pleas75627033plea__s
pleases94515483pleases
pleat74734473plea_t_
poets76024443poe__ts
polecats1248833polecats
pomaces132712123pomaces
praams10459643pr_aams
practic13312243pr_actic
practise12310143pr_actise
praefects1642873praefects
praelects1354353praelects
prahus11458243pr_ahus
prams96125513pr_a_ms
prances113618773prances
prangs94816233pr_angs
pranks124814723pr_anks
praos74923563pr_a_os
prases84429023pr_ases
prat65952043pr_a_t_
prate75135983pr_a_te
prates84633163pr_ates
praus74621753pr_a_us
prawns11509023pr_awns
praxes156215183pr_axes
praxis154012253pr_axis
prays105022433pr_a_ys
preaccuse1543543preaccuse
preached163412063preached
preacher153211373preacher
preachers16339573preachers
preacting142412533preacting
preadapts1444003preadapts
preadmits1444923preadmits
preadopts1445143preadopts
preadults1244283preadults
preaged11612333preaged
preallots1144513preallots
prealter1048863prealter
prealters1147773prealters
preamp1238993prea_mp
preanal9310713preanal
prearm104512353prea_rm
preaudits1265023preaudits
preaver121011613preaver
preavers13910263preavers
prebakes1639013prebakes
prebids12399883prebids
prebuys1444393prebuys
precava1445093precava
precents123015043precents
precepts14268893precepts
precess11310863precess
precincts1544993precincts
precise113518173pre_cise
precut102016533pre_cut
predacity1745603predacity
predate10616893predate
predates11615813predates
predawns1444363predawns
predict12315323predict_
preedits1168763preedits
preelects1356083preelects
preempts1444543preempts
preenact12410183preenact_
preens85020113pre_ens
preerects1345413preerects
prees75937173pre__es
prefabs1435163prefabs
preface14510923prefac_e
prefaced1638423prefaced
prefacer1537983prefacer
prefacers1636293prefacers
prefades1439533prefades
prefect141011073prefect_
prefers123713333prefers
prefocus1544743prefocus
pregames1339003pregames
preheats1339413preheats
prelacies13310053prelacies
prelacy1437583prelac_y
prelate9519693prelate
prelates10418573prelates
prelect111013833prelect_
prelims1139823prelims
premeds12389593premeds
premies113823063premies
premiss113513813premiss
prenames12311643prenames
preops104911943pre_ops
prepack1757643prepac_k
prepares122014163prepares
prepaste12139083prepaste
prepastes13128823prepastes
prepaves15189193prepaves
prepays1437483prepays
preplaces1578753preplaces
preps96220693pre__ps
prepuces1438583prepuces
prerace11414123prerac_e
presages11312203presages
presales10315263presales
presents103315643presents
preset84430983preset_
presifts1366593presifts
presorts105311683presorts
press75425953pre__ss
presses93523153presses
prest75736353pre_st_
presto84216203pre_sto
prestos93716083prestos
pretapes122811533pretapes
pretaste10139523pretaste
pretastes11119423pretastes
pretest9517633pretest
pretests10310013pretests
pretexts1735603pretexts
pretors9316813pretors
pretty11510873pre_tty
prevails1337663prevails
prevents133012293prevents
prevues1239263prevues
prewarms15406733prewarms
prewarns13456943prewarns
prexes154915953pre_xes
prexies163415003prexies
preyers124412363preyers
preys105717783pre__ys
prezes173614693pre_zes
priapus1134353priapus
prices104524543pr_ices
pricks144414263pr_icks
priests93810863priests
princes113015143princes
prints84320103pr_ints
privets122910053privets
proas75028803proa__s
probits112712573probits
products1376513products
profits122911243profits
projects1936413projects
projets1639163projets
prompts1337473prompts
prosects1239473prosects
protects1239743protects
protracts1347023protracts
races74943243_r_aces
racks115028853_r_acks
rafts87820633_r_afts
rants55935343_r_ants
rats46260373_r_a_ts
reach105123883_reac_h
reaches123423203_reaches
reacted103015713_reacted
reactor93011653_reactor
reactors103212283_reactors
readds84111643_readds
reads64835273_rea_ds
reales64934123_reales
realms84913493_realms
reals55038653_rea_ls
realty92713693_realty
reams75729623_rea_ms
reaps75626193_rea_ps
rearms85114653_rearms
rears54739653_rea_rs
reata54225393_rea_ta
reatas64021013_reatas
reaves94127573_reaves
rebaits9312573_rebaits
rebuts84015193_rebuts
recants93217093_recants
recaps103615733_recaps
recast83422773_recast
recasts93413533_recasts
recces10614913_recces
recits83621353_recits
recks115625133_re_cks
recs65734183_re_c_s
recta74220263_re_cta
recti73619623_re_cti
recto74520803_re_cto
rectos85718783_re_ctos
rectus83314633_re_ctus
recuts83817373_recuts
redact9419043_redact_
reenacts1036993reenacts
reests64618893_reests
refaces123216743_refaces
refects124012743_refects
refits94017653_refits
refracts13137383_refracts
rejects163910693_rejects
relaces93420883_relaces
relets64025673_relets
relicts94414593_relicts
relucts9369673_relucts
remits85622943_remits
rents55935183_re_nts
repacks15269543_repacks
repasts93611933_repasts
repots85621003_repots
reracks132310533_reracks
resects94115593_resects
resets65427613_resets
resits64725563_resits
rests54935873_re_sts
retacks132210713_retacks
retracts101111313_retracts
rets45352563_re__ts
revets94022173_revets
rewets94617213_rewets
roasts64915413_roasts
seats54844343_sea_ts
sects75622893_se_cts
seracs84418573serac_s
sprats85819933spr_a_ts
spreads1039763sprea_ds
sweats94814613swea_ts
tacts76524123__tacts
teats55636813_tea_ts
threats104311673threa_ts
traces85329933tr_aces
tracks124818843tr_acks
tract75635713tr_act_
traits65121983tr_aits
treacle939973treacle
treacles1039703treacles
treacly1237093treacly
treads74817923trea_ds
treat56240353trea_t_
treaty94414353trea_ty
trets55928023tre__ts
trevets10499973trevets
triacs83913223triac_s
truants738163truants
upbeats1195733upbea_ts
upreach1444693upreac_h
upreaches1654633upreaches
uprears9107493uprea_rs
ureas55826013urea__s
ureases74416723ureases
wheats125013223whea_ts
wracks154711113wr_acks
wreaks134711113wrea_ks
wreath124111193wrea_th
wreaths13338373wreaths
wrecks15418883wre_cks
wrests95313083wre_sts
yeasts96413053_yeasts

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 Limit1340274426.62320236.6
3Display Results4424420.1562833.3
 (SQL Overall)1786914427.18524870.0
 
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.