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

162 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
broaching1728766(None) 
breaching17269401breaching
roaching143210431_roaching
baching156017752b__aching
beaching164114142b_eaching
bleaching17287092bleaching
blotching1734962blotching
botching16359702b_otching
bracing123817612br_ac_ing
branching17289262branching
breathing15218372breathing
breeching17236472breeching
brocading1556252brocading
brunching17316482brunching
coaching164011962_coaching
crouching1746382crouching
grouching1644942grouching
poaching163510832_poaching
preaching172811162preaching
reaching143317202_reaching
abreacting1544533abreacting
aching126521973___aching
approaching2162453approaching
arching136216693ar__ching
attaching1545433attaching
avouching1843273avouching
backing165523443b__acking
barracking1944713barracking
bashing135422583b__ashing
batching163712093b_atching
bathing134816243b__athing
belching16349153b_elching
benching163411343b_enching
birching16328463b_irching
bitching163610623b_itching
blacking174213603b_lacking
blanching17297093blanching
blenching17276503blenching
bloating113512813bloa_ting
blocking174510573blo_cking
boarding123110233b_oarding
boasting113512503b_oasting
boating103721303b_oa_ting
borating113414503bora_ting
brachia141910423br_achi_a
brachial15219303br_achial
brachium1766113br_achium
bracings13369293br_ac_ings
bradding13268933br_adding
bragging13359333br_agging
braiding123112703br_aiding
brailing113514793br_ailing
braining113414683br_aining
braising113014563br_aising
braking143917713br_a_king
branding122513683br_anding
branning112911093br_anning
brassing112612303br_assing
braving133714613br_a_ving
bravoing1445993br_avoing
brawling143210043br_awling
braying134416313br_a_ying
brazing193715113br_a_zing
breading123515463brea_ding
breaking153914253brea_king
breaming133612513brea_ming
breasting1239583breasting
breathings16234313breathings
breechings18273723breechings
bricking173911403br_icking
broach133611113broach___
broached16309123broach_ed
broacher15329263broach_er
broachers16328153broachers
broaches153211623broach_es
broadening1444033broadening
broiling113112013bro_iling
brokering1636283brokering
broking143514823bro__king
bromating1439183bromating
bromizing2346583bromizing
bronchi14176313bronchi__
bronchia15195993bronchi_a
bronchial16175333bronchial
bronchium1843373bronchium
bronzing2037693bro_nzing
brooding122911373bro_oding
brooking153710703bro_oking
brooming132911143bro_oming
browning14299643bro_wning
browsing14319353bro_wsing
brushing14359963br_ushing
bunching163410703b_unching
caching156317503__caching
coacting133412703_coacting
couching163213263_couching
cracking174013903cr_acking
cranching17278733cranching
crashing143512633cr_ashing
croaking153712163croa_king
crocking174313443cro_cking
crunching17297003crunching
crutching17216073crutching
detaching1637263detaching
douching15349843_douching
drenching16256033drenching
encroaching1942993encroaching
frenching18267753frenching
frocking18309573fro_cking
frothing15208533fro_thing
gracing113216443gr_ac_ing
graphing1538533gr_aphing
groaning102410283groa_ning
grutching16224373grutching
hotching17309313_hotching
leaching143012833_leaching
loathing1247673_loathing
mooching16259063_mooching
mouching163110583_mouching
notching14288583_notching
ouching134314903__ouching
peaching163613643_peaching
pleaching17257083pleaching
pooching16328983_pooching
pouching163210413_pouching
preacting142412533preacting
racing95030533_r_ac_ing
racking144323663_r_acking
ranching141712043_ranching
reacting113317893_reacting
reproaching1944303reproaching
retching143412173_retching
roaming103215793_roa_ming
roaring82916003_roa_ring
roasting93012703_roasting
rocking143619633_ro_cking
roughing13278343_roughing
ruching133612933_r_uching
scooching1735073scooching
scorching1735633scorching
scotching1735653scotching
scrooching1843323scrooching
slouching15195723slouching
smooching1734883smooching
stomaching1844313stomaching
teaching143612603_teaching
torching142510083_torching
touching143211343_touching
trachling1537823tr_achling
tracing103720153tr_ac_ing
tracking153715463tr_acking
trashing122613223tr_ashing
trenching15227653trenching
troaking133310973troa_king
trocking153612423tro_cking
trothing122410843tro_thing
upreaching1844113upreaching
vouching17308233_vouching
wracking18349963wr_acking
wrathing15248923wr_athing
wreathing16266313wreathing
wrenching18276273wrenching

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.420425454.8
2DLD Change Limit1486411629.37615853.3
3Display Results1621620.0802025.0
 (SQL Overall)1786911629.87618093.5
 
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.