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

322 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
preached16341206(None) 
breached163411641breached
peached154315881p_eached
pleached16338061pleached
preacher153211371preacher
preaches153214891preaches
preacted132710941preacted
reached134619081_reached
upreached1764081upreached
beached154516552_beached
bleached16378562bleached
breacher153011502breacher
breaches153714122breaches
breathed14469642breathed
breeched16337382breeched
broached16309122broached
drenched15247912drenched
frenched17299432frenched
leached133715042_leached
peaced115818912p_eac_ed
peacher144216072p_eacher
peaches144120052p_eaches
peched144915342p_e_ched
perched154713242p_erched
pleaches153210432pleaches
poached154212402p_oached
preach133613922preach__
preachers16339572preachers
preachier1646922preachier
preachy17307312preach_y
preaged11612332prea_ged
prearmed1397992prearmed
prefaced1638422prefac_ed
prepacked20155652prepacked
prewashed1843922prewashed
reacher123718292_reacher
reaches123423202_reaches
reacted103015712_reacted
retched133814272_retched
roached133211832_roached
trenched14289852trenched
unreached1536882unreached
upreaches1654632upreaches
wreathed15257462wreathed
wrenched17748132wrenched
wretched17276532wretched
abreacted1444293abreacted
ached119227833___ached
approached2062363approached
arched125717323ar__ched
attached14165703attached
bached145519893__bached
beaches144120653_beaches
belched154011843_belched
benched154713943_benched
bleacher15358883bleacher
bleaches153410673bleaches
blenched16358053blenched
braced115420603br_ac_ed
braches144621223br_aches
brachet144020313br_achet
bracted12410933br_acted
branched163210453branched
breach134213723breach__
breachers16369853breachers
breaded115014063brea_ded
breamed124011593brea_med
breasted1138823breasted
breathe123711843breathe_
breather133610593breather
breathes134212903breathes
breeches15258673breeches
broacher15329263broacher
broaches153211623broaches
brunched16317853brunched
cached145419203__cached
clenched16257763clenched
coached153313843_coached
cracked163514743cr_acked
cranched163210413cranched
crashed134214213cr_ashed
creaked143413233crea_ked
creamed123913713crea_med
creased104315593crea_sed
created104323453crea_ted
creche13310763cre_che_
creches14313093cre_ches
creeshed1435703creeshed
crotched16428603crotched
crouched16359153crouched
crunched16328163crunched
crutched16307463crutched
deashed123411303_deashed
detached1537733detached
dreaded103612023drea_ded
dreamed114310633drea_med
drencher14257213drencher
drenches14309803drenches
eched116919223__e_ched
erected103213993ere_cted
etched123613703__etched
fetched163710473_fetched
fleeched17345823fleeched
flenched17267963flenched
fletched17306693fletched
fracted1339373fr_acted
freaked15399703frea_ked
frenches163311633frenches
frescoed1436053frescoed
freshed143312593fre_shed
graced105217903gr_ac_ed
graphed1498473gr_aphed
greased93812393grea_sed
greaved12408913grea_ved
grouched15356663grouched
grutched15284673grutched
impeached1942983impeached
kvetched2142783kvetched
leacher124014843_leacher
leaches123319343_leaches
leashed113211163_leashed
leched123716003_le_ched
leeched13369503_leeched
letched133912053_letched
orache114013593or_ache_
oraches124216473or_aches
outpreached1942433outpreached
outreached1645003outreached
paced106931683p__ac_ed
packed154822603p__acked
palaced124110783palac_ed
panache1458433panache_
panaches15310293panaches
parched154013693p_arched
pashed125923143p__ashed
patched153514623p_atched
paunched1645523paunched
peace95026083p_eac_e_
peaces106324083p_eac_es
peach125422493p_each__
peachers153213843p_eachers
peachier1548623p_eachier
peachy164510843p_each_y
peahen113410133p_ea_hen
peaked136117403p_ea_ked
pealed95322813p_ea_led
pearled10411553p_earled
pecked155019103p_e_cked
peracid12312993perac_id
percher143313423p_ercher
perches143717953p_erches
perished14310093perished
phreaked1834493phrea_ked
pieced113912103pie_c_ed
pierced12347593pierc_ed
pinched153812453p_inched
pitched153512923p_itched
placed114318003p_lac_ed
plashed133712643p_lashed
pleach134211243pleach__
pleaded113511263plea_ded
pleased103712073plea_sed
pleated103816633plea_ted
pleather1356653pleather
plenches153110623plenches
poacher143912323p_oacher
poaches144416943p_oaches
pooched152810083p_ooched
pouched153612773p_ouched
praised104214813pr_aised
pranced123714043pr_anced
pranged114512553pr_anged
pranked143712093pr_anked
prated94924923pr_a_ted
prawned1346743pr_awned
prayed124815433pr_a_yed
preaccused1743253preaccused
preachiest1746983preachiest
preachified2273093preachified
preachify2243053preachify
preachily1945143preachily
preaching172811163preaching
preachment1945943preachment
preact103220393preac__t
preacts113211363preac_ts
prealter1048863prealter
preambled1643893preambled
preaver121011613prea_ver
prebaked1737173prebaked
precede1239653pre_c_ede
preceded1438293preceded
precheck2144153pre_check
precised133213413precised
precited133013813precited
precode12311853pre_code
precoded1438863precoded
precured1339993precured
predated12513273predated
predicted1538913predicted
predried12309573predried
preed85128123pre___ed
preenacted1544973preenacted
preened103214993pre_ened
prefabbed1942323prefabbed
preface14510923prefac_e_
prefacer1537983prefac_er
prefaces15311063prefac_es
prefaded1537823prefaded
prefiled143310573prefiled
prefired144310753prefired
prefixed21357703prefixed
prelacies13310053prelacies
prelaunched1951923prelaunched
prelected1439133prelected
preluded1236473preluded
premed114617763pre__med
premised133013193premised
premixed20338013premixed
preowned1435213preowned
prepared132210873prepared
prepasted14137673prepasted
prepaved16177233prepaved
preplaced1676483preplac_ed
prepped11329903pre_pped
prepunched2073113prepunched
prerace11414123prerac_e_
presaged1238813presaged
prescind1338393prescind
prescored14409403prescored
presided12410553presided
pressed103317313pre_ssed
presumed1337973presumed
pretaped13339133pretaped
pretasted12147963pretasted
prettied1159253prettied
pretyped16306123pretyped
prevailed1536043prevailed
prevalued1544553prevalued
prevised143611073prevised
prevued1337143pre_vued
prewarmed17104563prewarmed
prewarned1594773prewarned
prewashes1744753prewashes
prewired14358473prewired
preyed125313203pre__yed
priced115018883pr_ic_ed
pricked164613833pr_icked
proceed12310553pr_oceed
psyched1843913p_syched
punched153512173p_unched
quenched2334103quenched
raced87635313_r_ac_ed
rachet115028973_r_achet
racked134526083_r_acked
ranched133113603_ranched
reaccede1354363_reaccede
reach105123883_reach__
reachers133515723_reachers
readded103310733_readded
readied93316623_readied
reamed94326123_rea_med
reaped94122453_rea_ped
reared75930013_rea_red
rearmed103912823_rearmed
reaved104523923_rea_ved
recaned102817203_recaned
rechew14310213_re_chew
recked134821803_re_cked
redacted12410243_redacted
reechoed1436083_reechoed
refaced133713573_refac_ed
rehashed1536063_rehashed
relaced103517213_relac_ed
rematched1745223_rematched
repacked17188743_repacked
repatched1745313_repatched
reproached1854723reproached
reracked15169123_reracked
rescued10410043_rescued
retacked15169273_retacked
retches123318513_retches
rewashed1546243_rewashed
roaches123616213_roaches
ruched124314633_r_uched
screeched17114343screeched
searched14209253_searched
sheathed1547223sheathed
sketched1835393sketched
stretched1546213stretched
teacher123714833_teacher
teaches122718353_teaches
teched124014433_te_ched
tetched133010773_tetched
traced94821583tr_ac_ed
trachea12311683tr_achea
tracheid1437583tr_acheid
trachled1438313tr_achled
tracked143716133tr_acked
trashed113514703tr_ashed
treachery1744693treachery
treacle939973treacle_
treacles1039703treacles
treaded95014283trea_ded
treadled1067123treadled
treated83618703trea_ted
trencher13279313trencher
trenches133512603trenches
upreach1444693upreach__
upreared1137083uprea_red
welched16298833_welched
wenched163910913_wenched
wracked174110113wr_acked
wrathed14298523wr_athed
wreaked15369023wrea_ked
wreathe13339053wreathe_
wreathen14256143wreathen
wreather14268603wreather
wreathes14299893wreathes
wrecked17418333wre_cked
wrencher16287783wrencher
wrenches163210233wrenches
wretches16257283wretches

Search took 9 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 Filter1786911461620.486367677.0
2DLD Change Limit1461623227.78018786.9
3Display Results3223220.1262555.6
 (SQL Overall)1786913228.39221293.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.