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

208 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
brioches1522725(None) 
brioche14275921brioche_
britches15278681britches
brooches15288191brooches
birches143412322b_irches
bitches144117062b_itches
boches134618522b__oches
braches144621222br_aches
branches153613802branches
breaches153714122breaches
breeches15258672breeches
bricoles122610302bricoles
brionies10310542brionies
broaches153211622broaches
broche133612102br_oche_
brunches153710452brunches
grinches1436952grinches
riches115022082_ri_ches
troches123715342tr_oches
aitches123014363_aitches
arches114822043ar__ches
babiches1735253babiches
baches135426943b__aches
barouches1644973barouches
batches144019613b_atches
beaches144120653b_eaches
beeches143413883b_eeches
belches143514343b_elches
benches143918603b_enches
berdaches1745053berdaches
bewitches1943823bewitches
bices95029963b_i_c_es
binocles1236413binocles
biochip1645323b_iochip
biochips1744843b_iochips
biocides1336933b_iocides
biomes103815253b_io_mes
birched15349913b_irched
birchen14347883b_irchen
bitched153212923b_itched
bitchen14349733b_itchen
blanches153311603blanches
bleaches153410673bleaches
blenches153310763blenches
blotches1537433blotches
bobeches1744483bobeches
bocces123912023b__occes
boche124216953b__oche_
borsches1536003borsches
boshes114721883b__oshes
botches143716023b_otches
braces108427773br_ac_es
brachet144020313br_achet
brachets154311983br_achets
brachs134415753br_ach_s
branched163210453branched
brashes124518463br_ashes
breached163411643breached
breacher153011503breacher
breachers16369853breachers
breathes134212903breathes
breeched16337383breeched
bribees11409283bri_bees
bribes105918533bri__bes
bricked164312063bri_cked
brickles162810283brickles
bricks144614623bri_c_ks
bricole112810493bricole_
brides94423513bri__des
bridges113911333bri_dges
bridles104114473bri_dles
bries74942153bri___es
brigades1236393brigades
brights133710233bri_ghts
brindles113710223brindles
brines85028853bri__nes
brinies93317913bri_nies
brios74725723brio___s
brises84927613bri__ses
brisses94314313bri_sses
bristles101510433bristles
briths115113863bri_th_s
brittles10178653brittles
broached16309123broached
broacher15329263broacher
broachers16328153broachers
brocades1358713br_ocades
brochures1644413br_ochures
brocket154013383br_ocket
brockets16328123br_ockets
brocks145214153br_oc_ks
brogues10719823br_ogues
bromes104719763br_o_mes
bronchos15206173bronchos
bronchus15204743bronchus
bronzes183510403br_onzes
brooch13368443brooch__
brookies1459143brookies
broses86524403br_o_ses
brothel12318193br_othel
brothels13277073br_othels
brother123311333br_other
brothers133410833br_others
broths115013923br_oth_s
browses124712693br_owses
brunched16317853brunched
bruncher15347783bruncher
brunchers16296253brunchers
brushes124014663br_ushes
bryonies1336843bryonies
bunches144116033b_unches
butches144315363b_utches
caroches15710693caroches
carroches1665893carroches
chinches18369363chinches
cinches144215773_cinches
cliches144213743cli_ches
clinches153910363clinches
cloches144113713_cloches
cooches143515833_cooches
cranches153114543cranches
cratches153012543cratches
creches14313093cr_eches
crochet143616663cr_ochet
crochets15359833cr_ochets
crotches153411303crotches
crouches153711293crouches
crunches153711353crunches
crutches15359593crutches
ditches133215713_ditches
drenches14309803drenches
enriches1337263enri_ches
fiches145219533_fi_ches
filches153410723_filches
finches153914193_finches
fitches153516193_fitches
flinches16358953flinches
flitches16388463flitches
frenches163311633frenches
glitches14296663glitches
grouches14328213grouches
grutches14285853grutches
hitches153616273_hitches
hooches153812523_hooches
idiocies1145223idiocies
inches114419673__inches
itches114916213__itches
kirsches1743843kirsches
liches114724293_li_ches
miches134320733_mi_ches
mooches143714453_mooches
niches114419143_ni_ches
oraches124216473or_aches
orioles7412993orio_les
painches1588913painches
panoches1548123panoches
penoches1538933penoches
pinches144117933_pinches
pitches143617753_pitches
pooches143214163_pooches
preaches153214893preaches
prices104524543pri_c_es
princes113015143princ_es
priories10312453priories
quiches2139333qui_ches
quitches2236193quitches
ranches123620113_ranches
ratches123620463_ratches
reaches123423203_reaches
retches123318513_retches
rices75536153_ri_c_es
richen113812513_ri_chen
richens12349733_ri_chens
richer114015043_ri_cher
richest122813683_ri_chest
ricochet1547083_ricochet
ricochets1643413_ricochets
roaches123616213_roaches
rochet115423003_r_ochet
rochets124213473_r_ochets
rotches123515703_rotches
rouches124217893_rouches
ruches114819583_r_uches
scooches15188413scooches
scrooches1645703scrooches
seiches12513813sei_ches
smirches1535993smirches
smooches15217263smooches
snitches13148983snitches
soroches1338803soroches
stitches131410593stitches
switches16159133switches
tranches132915513tranches
trenches133512603trenches
trices84826333tri_c_es
triodes84012503trio_des
trioses75015653trio_ses
troche113112513tr_oche_
trochee122613883tr_ochee
trochees132510183tr_ochees
twitches16156373twitches
wiches144418753_wi_ches
winches154714373_winches
witches152715793_witches
wrenches163210233wrenches
wretches16257283wretches
writhes134811703wri_thes
zilches21326303_zilches

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.423422437.4
2DLD Change Limit1461622087.46619577.0
3Display Results2082080.0802600.0
 (SQL Overall)1786912087.96922423.3
 
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.