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

270 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
preacher15321137(None) 
breacher153011501breacher
peacher144216071p_eacher
preached163412061preached
preachers16339571preachers
preaches153214891preaches
preachier1646921preachier
reacher123718291_reacher
bleacher15358882bleacher
breached163411642breached
breachers16369852breachers
breaches153714122breaches
breather133610592breather
broacher15329262broacher
drencher14257212drencher
leacher124014842_leacher
peached154315882p_eached
peachers153213842p_eachers
peaches144120052p_eaches
peachier1548622p_eachier
percher143313422p_ercher
pleached16338062pleached
pleaches153210432pleaches
pleather1356652pleather
poacher143912322p_oacher
preach133613922preach__
preachy17307312preach_y
preacted132710942preacted
prealter1048862prealter
preaver121011612prea_ver
prefacer1537982prefac_er
reached134619082_reached
reachers133515722_reachers
reaches123423202_reaches
teacher123714832_teacher
treachery1744692treachery
trencher13279312trencher
upreached1764082upreached
upreaches1654632upreaches
wreather14268602wreather
wrencher16287782wrencher
archer115016243ar__cher
attacher13125713attacher
aweather1434263aweather
beached154516553_beached
beaches144120653_beaches
beachier1538803_beachier
belcher143511493_belcher
bencher144113483_bencher
bleached16378563bleached
bleachers16297923bleachers
bleaches153410673bleaches
blencher15308393blencher
bracer104620583br_ac_er
braches144621223br_aches
brachet144020313br_achet
brasher124515243br_asher
breach134213723breach__
breaker133912923brea_ker
breathe123711843breathe_
breathed14469643breathed
breathers14319103breathers
breathes134212903breathes
breathier1435383breathier
breeched16337383breeched
breeches15258673breeches
broached16309123broached
broachers16328153broachers
broaches153211623broaches
bruncher15347783bruncher
clencher15277973clencher
coacher143714123_coacher
cracker153114173cr_acker
crasher124616163cr_asher
creakier14328333creakier
creamer113714093crea_mer
creamier12319063creamier
creaser94415743crea_ser
creasier103210193creasier
creche13310763cre_che_
creches14313093cre_ches
cruncher15338073cruncher
detacher1437543detacher
dreamer104110843drea_mer
dreamier11287293dreamier
drearier9297923drearier
drenched15247913drenched
drenchers15296103drenchers
drenches14309803drenches
erecter93113393ere_cter
etcher113912943__etcher
feather133613503_feather
fetcher153510393_fetcher
fletcher16306663fletcher
freakier15246483freakier
frenched17299433frenched
frenches163311633frenches
frescoer1345983frescoer
fresher132612643fre_sher
greaser83913083grea_ser
greasier9298083greasier
greater84416493grea_ter
heather133914853_heather
impeacher1843093impeacher
kvetcher2052813kvetcher
leached133715043_leached
leachers133712813_leachers
leaches123319343_leaches
leachier1337253_leachier
leather103815783_leather
lecher113415853_le_cher
orache114013593or_ache_
oraches124216473or_aches
pacer96131613p__ac_er
pacier105018683p__acier
packer144223403p__acker
panache1458423panache_
panaches15310283panaches
parachor1546653parachor
patcher143515143p_atcher
peace95026083p_eac_e_
peaced115818913p_eac_ed
peaces106324083p_eac_es
peach125422493p_each__
peachy164510843p_each_y
peahen113410133p_ea_hen
peakier134411443p_eakier
pearler9310373p_earler
pearter9412743p_earter
peatier94017233p_eatier
peched144915343p_e_ched
pecker144615363p_e_cker
perched154713243p_erched
perchers153611523p_erchers
perches143717953p_erches
phreaker1735053phrea_ker
piecer105213083pie_c_er
piercer11337773pierc_er
pincher143812713p_incher
pinscher1544813pinscher
pitcher143813713p_itcher
placer105117743p_lac_er
plasher124215033p_lasher
pleach134211243pleach__
pleader103511753plea_der
pleaser93912343plea_ser
pleater93916333plea_ter
pleathers1446453pleathers
plenches153110623plenches
poached154212403p_oached
poachers152910763p_oachers
poaches144416943p_oaches
poachier1556823p_oachier
praiser93413943pr_aiser
prancer113613383pr_ancer
prater84825353pr_a_ter
prawner1246803pr_awner
prayer114815293pr_a_yer
preachiest1746983preachiest
preachify2243053preachify
preachily1945143preachily
preaching172811163preaching
preachment1945943preachment
preact103220393preac__t
preacts113211363preac_ts
preaged11612333prea_ged
prealters1147773prealters
prearmed1397993prearmed
preavers13910263prea_vers
precancer1547093precancer
precheck2144153pre_check
preciser123411663preciser
preclear1245423pre_clear
precure11312553pre_cure
preener93114833pre_ener
preface14510923prefac_e_
prefaced1638423prefac_ed
prefacers1636293prefac_ers
prefaces15311063prefac_es
prefer113813203pre__fer
prelacies13310053prelacies
preluder1135733preluder
premier113515633pre_mier
preorder1136463preorder
prepacked20155653prepacked
preparer12169643preparer
preppier1156643preppier
prerace11414123prerac_e_
presager1138443presager
prescore124812373prescore
presider11410423presider
presser93717623pre_sser
prester93519623pre_ster
presumer1247583presumer
prettier1069043prettier
prevailer1445153prevailer
prewashed1843923prewashed
prewashes1744753prewashes
preyer114413733pre__yer
pricer103918293pr_ic_er
pricier113313113pr_icier
pricker154013413pr_icker
puncher143311673p_uncher
quencher2234123quencher
racer75233023_r_ac_er
rachet115028973_r_achet
racier85120973_r_acier
racker124824553_r_acker
rancher123013633_rancher
rasher95024123_r_asher
rather94319743_r_ather
reach105123883_reach__
reacted103015713_reacted
reactor93011653_reactor
reader73628293_rea_der
readier83117423_readier
realer63528593_rea_ler
realter73716313_realter
reamer84325213_rea_mer
reaper84223143_rea_per
rearer64928913_rea_rer
reaver94524733_rea_ver
rechew14310213_re_chew
reechier1336673_reechier
regather1236733_regather
reproacher1764273reproacher
rescuer939033_rescuer
retched133814273_retched
retches123318513_retches
richer114015043_r_icher
roached133211833_roached
roaches123616213_roaches
screecher16144483screecher
searcher13209103_searcher
sheather1458233sheather
sketcher1735433sketcher
spreader1137483sprea_der
stretcher1446293stretcher
teachers133212393_teachers
teaches122718353_teaches
tracer84820233tr_ac_er
trachea12311673tr_achea
tracker133515173tr_acker
trasher104416133tr_asher
treacle939973treacle_
treacles1039703treacles
treaclier1144153treaclier
treader84113833trea_der
treadler936863treadler
treater74219833trea_ter
trenched14289853trenched
trenchers14288073trenchers
trenches133512603trenches
unreached1536883unreached
upreach1444693upreach__
weather133513223_weather
welcher15319393_welcher
wencher153811133_wencher
wreaker143610043wrea_ker
wreathe13339053wreathe_
wreathed15257463wreathed
wreathen14256143wreathen
wreathers15257493wreathers
wreathes14299893wreathes
wrecker16367603wre_cker
wrenched17748133wrenched
wrenchers17256333wrenchers
wrenches163210233wrenches
wretched17276533wretched
wretches16257283wretches

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 Filter1786911461620.453394461.4
2DLD Change Limit1461622707.14020470.9
3Display Results2702700.0932903.2
 (SQL Overall)1786912707.68623248.9
 
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.