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

173 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
borsches153600(None) 
borschts1542851borschts
birches143412322bir_ches
bobeches1744482bobeches
boches134618522bo__ches
boraces113716852borac_es
borsch1336132borsch__
borscht1445992borsch_t
borshts1266542bors_hts
boshes114721882bo_s_hes
botches143716022bo_tches
braches144621222b_raches
broaches153211622broaches
brooches15288192brooches
kirsches1743842kirsches
oraches124216472_oraches
porches143815672por_ches
soroches1338802soroches
torches123715432tor_ches
arches114822043_ar_ches
babiches1735253babiches
baches135426943b__aches
barouches1644973barouches
bashes115631393b_as_hes
batches144019613b_atches
beaches144120653b_eaches
beeches143413883b_eeches
belches143514343b_elches
benches143918603b_enches
berdaches1745053berdaches
birched15349913bir_ched
birchen14347883bir_chen
birses84717733birs__es
bitches144117063b_itches
blanches153311603blanches
bleaches153410673bleaches
blenches153310763blenches
blotches1537433blotches
blushes124314823blus_hes
bobeche1643843bobeche_
bocces123912023bo__cces
boccies133311513bo_ccies
boche124216953bo__che_
bodices12710593bodic_es
bolshies1338693bolshies
boracites1347953boracites
borages103917163bor_ages
boranes93720403bor_anes
borates94823013bor_ates
boraxes163511633bor_axes
bordures1136173bordures
boreases10310253boreases
borecoles1345973borecoles
bores76448253bor___es
borescopes1645173borescopes
borides10515153bor_ides
bornites10310983bornites
borsht11813503bors_h_t
borstals1037463borstals
bortzes1838223bor_tzes
boscages1366643bo_scages
bosques18217973bo_sques
bosses85925403bo_s_ses
bossies94116833bo_ssies
botched153611903bo_tched
botcher143613223bo_tcher
botchers153511543bo_tchers
bouchee143313543bo_uchee
bouchees15339533bo_uchees
boucles113113003bo_ucles
bounces113813683bounc_es
bourses94014303bours__es
bouses84931783bous__es
bowses115718863bows__es
braces108427773b_rac_es
brachet144020313b_rachet
brachets154311983b_rachets
brachs134415753b_rach_s
branches153613803branches
brashes124518463b_rashes
breaches153714123breaches
breeches15258673breeches
brioches15227253brioches
britches15278683britches
broached16309123broached
broacher15329263broacher
broachers16328153broachers
broche133612103b_roche_
bronchos15206173bronchos
bronchus15204743bronchus
broses86524403bros__es
brunches153710453brunches
brushes124014663b_rushes
bunches144116033b_unches
burses84425513burs__es
bushes115226113b_us_hes
butches144315363b_utches
caroches15710693caroches
coaches144018693co_aches
conches144019813co_nches
cooches143515833co_oches
coracles121811163coracles
corniches1666673corniches
corsages11310363corsages
corses84433463cors__es
coshes115022783co_s_hes
couches144020473co_uches
creches14313093_creches
crotches153411303crotches
crouches153711293crouches
curches143512743cur_ches
douches134315233do_uches
earaches13411303earaches
enriches1337263enriches
flysches1933123flysches
forces114422133for_c_es
forsakes1536893forsakes
girshes11248293girs_hes
gorses74723293gors__es
gouaches1436193gouaches
groschen1442973groschen
grouches14328213grouches
gurshes112210033gurs_hes
hooches153812523ho_oches
hootches1656973hootches
horses94729343hors__es
horstes104516113hors_tes
hotches153814363ho_tches
joshes165114853jo_s_hes
kitsches1734073kitsches
larches124416443lar_ches
loaches123613983lo_aches
lurches123311663lur_ches
marches143921173mar_ches
marshes123615373mars_hes
mensches1536303mensches
merches144013763mer_ches
mooches143714453mo_oches
moshes115222873mo_s_hes
mouches143815963mo_uches
nonsuches1444493nonsuches
noshes96618233no_s_hes
notches123513653no_tches
orache114013593_orache_
oracles93212423_oracles
orchis11710773_or_chis
ouches114322183_o_uches
parches143720003par_ches
perches143717953per_ches
poaches144416943po_aches
pooches143214163po_oches
potiches1539203potiches
pouches144116743po_uches
putsches1535313putsches
qurshes19228573qurs_hes
riches115022083__riches
roaches123616213ro_aches
roscoes9310923ro_scoes
rotches123515703ro_tches
rouches124217893ro_uches
ruches114819583__ruches
scorches15189143scor_ches
soroche1237183soroche_
torched133511353tor_ched
torsades937213torsades
torses64727953tors__es
toshes94520103to_s_hes
touches125118343to_uches
troches123715343_troches
tusches1237903_tusches
vouches153914113vo_uches
wooshes13169883woos_hes
worses95522953wors__es

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.420425454.8
2DLD Change Limit1461621737.33019940.2
3Display Results1731730.0762276.3
 (SQL Overall)1786911737.82622833.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.