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

287 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
borsch133613(None) 
borscht1445991borscht
birch124914022bir_ch
boric98024222boric_
borsches1536002borsches
borschts1542852borschts
borsht11813502borsht
bosh96328972bo_s_h
botch126717452bo_tch
brach126123302b_rach
broach133611112broach
brooch13368442brooch
kirsch1532712kirsch
orach105219232_orach
porch125918622por_ch
torch107420932tor_ch
abroach1446213abroach
arch98628443_ar_ch
bach116131393b__ach
barca91319433bar_ca
baric96125693baric_
bars66564093bars__
bash915240163b_as_h
batch124620103b_atch
beach124623893b_each
beech124315503b_eech
belch124415503b_elch
bench125619503b_ench
berth104917883ber_th
biotech14104493biotech
birse74517403birs_e
birses84717733birses
birth105619873bir_th
bitch125017763b_itch
blanch133410853blanch
bleach133611403bleach
blench133710453blench
blotch13197143blotch
blush105115313blus_h
boarish123911913boarish
boars75229603boars__
boas66150833boas__
boast75935703boas_t
boasts85017923boasts
bobeche1643843bobeche
bobs86340653bobs__
bocce114313113bo_cce
bocci113512713bo_cci
boche124216953bo__che
bock126032513bo__ck
bodice11711423bodice
bods76244713bods__
bogs75742753bogs__
bolshy1444883bolshy
bolson8410683bolson
bonaci10310963bonaci
bonsai838463bonsai
boorish123712593boorish
boors74325013boors__
boos67955033boos__
boost75132473boos_t
boosts86115013boosts
booth105522013bo_oth
bops86037983bops__
bora66141633bor__a
boraces113716853boraces
boracic1338723boracic
borage93917013borage
boral75831703bor_al
borals86721913borals
borane84620213borane
boras75938303bor_as
borate85026153borate
borax145918723bor_ax
bordel94514573bordel
border94419973border
bore66051333bor__e
boreal84817213boreal
boreas85421733boreas
bored85034303bor_ed
boreen8314313boreen
borer75131273bor_er
borers85122683borers
bores76448253bor_es
boride9415903boride
boring94724873boring
bork106933823bor__k
borked135117293borked
borks115727703bor_ks
born67338413bor__n
borne77926793bor_ne
boron76727143bor_on
borons85520543borons
borough1344513borough
borrow114310723borrow
borshts1266543borshts
borstal939043borstal
bort65960963bor__t
borts76735453bor_ts
borty105522833bor_ty
bortz165722203bor_tz
borzoi1736623borzoi
bos57966813bo_s__
bosk105825733bo_s_k
bosks115218853bo_sks
bosky145612393bo_sky
bosom95516923bo_som
boson76019733bo_son
boss65938343bo_s_s
bossed94816533bossed
bosses85925403bosses
bossy105515973bo_ssy
bosun75113593bo_sun
botchy16537823bo_tchy
both96533433bo__th
bots66453953bots__
bough115719313bo_ugh
bounce104014833bounce
bouncy13409073bouncy
bourse84414333bours_e
bourses94014303bourses
boursin938283boursin
bouse75931853bous_e
boused95322883boused
bouses84931783bouses
bousy104917843bous_y
bows96242863bows__
bowse105420633bows_e
bowsed125715973bowsed
bowses115718863bowses
boyish142911233boyish
boys96737333boys__
brace95629273b_race
brachs134415753b_rachs
bract96332723b_ract
branch134014773branch
brash106221563b_rash
breach134213723breach
breech13348263breech
brick134618153b_rick
brith104924373b_rith
broche133612103b_roche
brock136017073b_rock
bronc91714343bronc_
bronchi14176313bronchi
broncho14206463broncho
bronco10179493bronco
broncs101611153broncs
bros65635663bros__
brose75227033bros_e
broses86524403broses
brosy106115383bros_y
broth106521093b_roth
brugh115414293b_rugh
brunch13329353brunch
brush105917473b_rush
bunch125118603b_unch
burgh115216033bur_gh
burs65847423burs__
bursa74921523burs_a
bursae84515603bursae
bursal84414823bursal
bursar85413253bursar
bursas85318273bursas
burse75527253burs_e
burses84425513burses
burst75332243burs_t
bursts85116243bursts
bush96630713b_us_h
butch125416543b_utch
caroch13911763caroch
coach125919453co_ach
conch124620073co_nch
cooch124916833co_och
cors66656443cors__
corsac10410173corsac
corsacs1139013corsacs
corse75036183cors_e
corses84433463corses
corset85636223corset
cosh96127623co_s_h
couch125320113co_uch
crotch133410083crotch
crouch133910203crouch
curch124415413cur_ch
dors56747603dors__
dorsa64617283dors_a
dorsad8408973dorsad
dorsal74613943dorsal
dorsel75315503dorsel
dorser74819173dorser
dorsum947623dorsum
enrich1138943enrich
flysch1732893flysch
force105324273for_ce
forth116222673for_th
frosh115713403fros_h
girsh95310023girs_h
gorse65926813gors_e
gorses74723293gorses
gorsy95915783gors_y
gosh86123423go_s_h
grouch12318473grouch
gursh94512333gurs_h
harsh116418053hars_h
hooch135813703ho_och
hootch14386403hootch
horah117922043hor_ah
horse86132653hors_e
horsed105321083horsed
horses94729343horses
horsey125115403horsey
horst85833513hors_t
horste94817413horste
horsts95817513horsts
horsy116318393hors_y
hotch136214723ho_tch
josh145117613jo_s_h
kitsch1533353kitsch
kors85933013kors__
larch105919793lar_ch
loach105116363lo_ach
loch95527133lo__ch
lorica8310443lorica
lurch104814633lur_ch
march125622893mar_ch
marsh105320853mars_h
mensch13387083mensch
merch125417963mer_ch
moloch1356483moloch
mooch125313613mo_och
morph121712513mor_ph
mors65950063mors__
morse76032703mors_e
morsel85815893morsel
mosh95227603mo_s_h
mouch124715803mo_uch
nonsuch1244683nonsuch
north86018273nor_th
nosh76223543no_s_h
notch105613323no_tch
orache114013593_orache
orc57034923_or_c_
orca65522773_or_ca
orcs67025433_or_cs
ors35750113_ors__
ouch95724633_o_uch
parch125123003par_ch
perch124518833per_ch
poach124917863po_ach
pooch124815303po_och
posh95427323po_s_h
pouch124617083po_uch
putsch1334933putsch
qursh174110843qurs_h
rich97025543__rich
roach105717003ro_ach
rotch105815933ro_tch
scorch13198093scor_ch
soroche1237183soroche
torah87125273tor_ah
torc66333353tor_c_
torchy14549533tor_chy
torcs75123763tor_cs
toric76529313toric_
torics85118353torics
toroth95512963toroth
tors46157383tors__
torse55833333tors_e
torses64727953torses
torsi57423363tors_i
torsk94915773tors_k
torsks10549123torsks
torso56922143tors_o
torsos64815733torsos
tosh74826813to_s_h
touch106519393to_uch
vouch134611903vo_uch
woosh113710733woos_h
worse86525263wors_e
worsen95513873worsen
worser95117523worser
worses95522953worses
worset96726583worset
worst86330133wors_t
worsts96014333worsts
worth117120523wor_th

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162876.51317306.3
3Display Results2872870.0803587.5
 (SQL Overall)1786912876.73326539.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.