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

240 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
preaching17281116(None) 
breaching17269401breaching
peaching163613641p_eaching
pleaching17257081pleaching
preacting142412531preacting
reaching143317201_reaching
upreaching1844111upreaching
beaching164114142_beaching
bleaching17287092bleaching
breathing15218372breathing
breeching17236472breeching
broaching17287662broaching
drenching16256032drenching
frenching18267752frenching
leaching143012832_leaching
peacing124117072p_eac_ing
peching154513902p_e_ching
perching163711632p_erching
poaching163510832p_oaching
preachier1646922preachier
preachify2243052preachify
preachily1945142preachily
preachingly2242902preachingly
prearming14139222prearming
prefacing17118742prefac_ing
prepacking2145772prepacking
prewashing1944942prewashing
reacting113317892_reacting
retching143412172_retching
roaching143210432_roaching
teaching143612602_teaching
trenching15227652trenching
wreathing16266312wreathing
wrenching18276272wrenching
abreacting1544533abreacting
aching126521973___aching
approaching2162453approaching
arching136216693ar__ching
attaching1545433attaching
baching156017753__baching
belching16349153_belching
benching163411343_benching
blenching17276503blenching
bracing123817613br_ac_ing
branching17289263branching
breading123515463brea_ding
breaking153914253brea_king
breaming133612513brea_ming
breasting1239583breasting
breathings16234313breathings
breechings18273723breechings
brunching17316483brunching
caching156317503__caching
clenching17266303clenching
coaching164011963_coaching
cracking174013903cr_acking
cranching17278733cranching
crashing143512633cr_ashing
creaking153414123crea_king
creaming133413143crea_ming
creasing113314443crea_sing
creating113921953crea_ting
creeshing1536243creeshing
crouching1746383crouching
crunching17297003crunching
crutching17216073crutching
deashing134210953_deashing
detaching1637263detaching
dreading113712803drea_ding
dreaming124011063drea_ming
eching126315563__e_ching
erecting112415063ere_cting
etching134511843__etching
fetching17298413_fetching
fleeching18305013fleeching
flenching18296703flenching
fletching18256143fletching
freaking163611453frea_king
frescoing1544683frescoing
freshing152611023fre_shing
gracing113216443gr_ac_ing
graphing1538533gr_aphing
greasing102811393grea_sing
grouching1644943grouching
grutching16224373grutching
impeaching2043373impeaching
kvetching2242903kvetching
leashing123310313_leashing
leching134613653_le_ching
leeching14318373_leeching
letching143810263_letching
outpreaching2042343outpreaching
outreaching1744913outreaching
pacing114522753p__ac_ing
packing164420723p__acking
parching164313053p_arching
pashing135120513p__ashing
patching163212753p_atching
peachier1548623p_eachier
peaking144317693p_ea_king
pealing104123203p_ea_ling
pearling11912013p_earling
pecking164017783p_e_cking
perishing1539533perishing
phreaking1936473phrea_king
piecing12410453pie_c_ing
piercing1346663pierc_ing
pinching163711053p_inching
pitching163411113p_itching
placing123815283p_lac_ing
plashing143311063p_lashing
pleading123011443plea_ding
pleasing112611593plea_sing
pleating112916053plea_ting
pooching16328983p_ooching
pouching163210413p_ouching
praising113214563pr_aising
prancing132612163pr_ancing
pranging123012723pr_anging
pranking153813383pr_anking
prating103424453pr_a_ting
prawning1446963pr_awning
praying133717323pr_a_ying
preaccusing1843163preaccusing
preach133613923preach___
preached163412063preach_ed
preacher153211373preach_er
preachers16339573preachers
preaches153214893preach_es
preachiest1746983preachiest
preachifying2652343preachifying
preachiness1844283preachiness
preachment1945943preachment
preachy17307313preach__y
preassign1244573preassign
prebaking1838063prebaking
prebuying1734303prebuying
precasting15169833precasting
preceding15129363preceding
prechill1546193pre_chill
precising14413273precising
precoding15109733precoding
precuring1439423precuring
predating13514653predating
predicting1649873predicting
predrying1645343predrying
preeing103817673pre__eing
preenacting16125373preenacting
preening113115843pre_ening
prefabbing2042583prefabbing
prefading16149033prefading
prefiling1549533prefiling
prefiring1559073prefiring
prefixing2246783prefixing
prehiring1548383prehiring
prelaunching2051503prelaunching
prelecting15310163prelecting
preluding1337053preluding
premising14412413premising
premixing2157803premixing
preparing14311643preparing
prepasting15168883prepasting
prepaving1787233prepaving
prepaying1747973prepaying
preplacing1746003preplac_ing
prepping12309763pre_pping
prepunching2142563prepunching
presaging1339393presaging
prescind1338393presc_ind
prescoring1547433prescoring
presiding13510903presiding
pressing112516443pre_ssing
presuming1437663presuming
pretaping1439133pretaping
pretasting13239283pretasting
prettying1536043prettying
pretyping1764943pretyping
prevailing1656723prevailing
prevaluing1644273prevaluing
prevising15510873prevising
prevuing1457253pre_vuing
prewarming18145173prewarming
prewarning16135193prewarning
prewiring1547893prewiring
preying133114553pre__ying
pricing123417343pr_ic_ing
pricking173212603pr_icking
psyching1934483p_syching
punching163310123p_unching
quenching2443923quenching
racing95030533_r_ac_ing
racking144323663_r_acking
ranching141712043_ranching
readding11411363_readding
reading93327213_rea_ding
readying13410223_readying
reaming103924013_rea_ming
reaping103621213_rea_ping
rearing83128783_rea_ring
rearming111413613_rearming
reaving113820533_rea_ving
recaning111416693_recaning
recking144319923_re_cking
redacting13612303_redacting
reechoing1545293_reechoing
refacing142512813_refac_ing
rehashing1647113_rehashing
relacing112516043_relac_ing
rematching1844913_rematching
repacking1838283_repacking
repatching1844993_repatching
reproaching1944303reproaching
reracking1639313_reracking
rescuing1139623_rescuing
retacking1658973_retacking
reteaching1636023reteaching
rewashing1676903_rewashing
ruching133612933_r_uching
screeching1843643screeching
searching1538343_searching
sheathing1636873sheathing
sketching1935083sketching
spreading1339653sprea_ding
stretching1645813stretching
teachings15296553_teachings
trachling1537823tr_achling
tracing103720153tr_ac_ing
tracking153715463tr_acking
trashing122613223tr_ashing
treading103515333trea_ding
treadling1137503treadling
treating92519613trea_ting
unteaching1645493unteaching
uprearing1238373uprea_ring
welching17287363_welching
wenching17328863_wenching
wracking18349963wr_acking
wrathing15248923wr_athing
wreaking163010213wrea_king
wrecking18328153wre_cking

Search took 10 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 Filter1786911486410.470380193.6
2DLD Change Limit1486412408.57617332.2
3Display Results2402400.1102181.8
 (SQL Overall)1786912409.15619516.3
 
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.