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

309 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
breech1334826(None) 
beech124315501b_eech
breach134213721breach
beach124623892b_each
beechy16397502b_eechy
belch124415502b_elch
bench125619502b_ench
beseech1453872beseech
bleach133611402bleach
blench133710452blench
brach126123302br_ach
branch134014772branch
breath113916262breath
bree67241262bree__
breeched16337382breeched
breeches15258672breeches
breed85526692bree_d
breeds94914882breeds
breeks125310792breeks
brees75632552bree_s
breeze17298962breeze
breezy20295852breezy
broach133611112broach
brooch13368442brooch
brunch13329352brunch
creesh11328332creesh
dreich12377722dreich
drench12369592drench
fleech14367342fleech
french143511212french
leech104913212_leech
preach133613922preach
reach105123882_reach
reecho11318652_reecho
reechy14367822_reechy
retch104818302_retch
screech1435222screech
speech1347562speech
trench114211612trench
unbreech1542232unbreech
wrench14439352wrench
wretch14326532wretch
abreact11310823abreact
abroach1446213abroach
arch98628443ar__ch
areca75618633ar_eca
areic73219393areic_
bach116131393b__ach
batch124620103b_atch
beachy164011253b_eachy
beck126226573b__eck
bedeck1536213bedeck
bedrench1644153bedrench
bee56262403b_ee__
beechen14367703b_eechen
beeches143413883b_eeches
beedi8711663b_eedi
beef96233683b_ee_f
beefs105618563b_eefs
beefy135313833b_eefy
been65335783b_ee_n
beep85931213b_ee_p
beeps95320973b_eeps
beer65635993b_ee_r
beers75628393b_eers
beery105220123b_eery
bees65453383b_ee_s
beet66457543b_ee_t
beets76131443b_eets
bereft114317303bereft
beret74946363bere_t
berets85822523berets
berth104917883b_erth
beth96629233b__eth
biotech14104493biotech
birch124914023b_irch
bisect10312873bisect
bitch125017763b_itch
blanch133410853blanch
bleed85019803blee_d
bleeds95211593bleeds
bleep95013453blee_p
bleeps10499103bleeps
blotch13197143blotch
bobeche1643843bobeche
boreen8314313boree_n
boreens9310403boreens
borsch1336133borsch
botch126717453b_otch
brace95629273br_ace
braced115420603braced
bracer104620583bracer
braces108427773braces
brachs134415753br_achs
bract96332723br_act
brae65639113brae__
braes75735053brae_s
branchy17357913branchy
brash106221563br_ash
breached163411643breached
breacher153011503breacher
breaches153714123breaches
bread85523113br_ead
breads95419203breads
breadth1365993breadth
bready124511183bready
break115319403br_eak
breaks124816423breaks
bream95121813br_eam
breams104815043breams
breast8319633breast
breathe123711843breathe
breaths124411183breaths
breathy15328033breathy
breccia1344453breccia
brecham1646833br_echam
brechan1437223br_echan
bred75130973br_e_d
brede85520503br_ede
bredes94818473bredes
breeching17236473breeching
breeder103210043breeder
breezed19287053breezed
breezes18318693breezes
bregma1134963bregma
bren65629563br_e_n
brens75823363br_ens
brent75734133br_ent
brents84717273brents
breve105317053br_eve
breves115516423breves
brevet115717333brevet
brevetcy1841723brevetcy
brevets12519393brevets
brew95023563br_e_w
brewed125411873brewed
brewer114812553brewer
brewers123811063brewers
brewery15376963brewery
brewis11469983brewis
brews105617073br_ews
brick134618153br_ick
brie65837903brie__
brief105422603brie_f
briefs115510073briefs
brier74527403brie_r
briers85319733briers
briery114510773briery
bries74942153brie_s
brioche14275923brioche
brith104924373br_ith
broche133612103br_oche
brock136017073br_ock
bronc91714343bronc_
bronchi14176313bronchi
broncho14206463broncho
bronco10179493bronco
broncs101611153broncs
broth106521093br_oth
brugh115414293br_ugh
brush105917473br_ush
bunch125118603b_unch
butch125416543b_utch
clench133910053clench
cranch133613533cranch
cratch134110793cratch
creche13310763cr_eche
creed85727393cree_d
creeds94714773creeds
creek114917393cree_k
creeks124812923creeks
creel75121483cree_l
creels84416943creels
creep95218103cree_p
creeps104213623creeps
creepy13418803creepy
creese84014333creese
crotch133410083crotch
crouch133910203crouch
crunch13349503crunch
crutch13408243crutch
dreck124812803dr_eck
dree56638323dree__
dreed75222843dree_d
drees65628523dree_s
dreigh11246443dreigh
driegh11254563driegh
each95530583__each
erect74129333er_ect
etch95419143__etch
fetch134913473_fetch
fleece11369903fleece
fleecy14266483fleecy
flench144010813flench
fletch14388193fletch
free75940183free__
freed95223543free_d
freely12310963freely
freer86021243free_r
freers94717303freers
frees86131393free_s
freest95318283freest
freeze18349513freeze
fresco1136473fresco
fresh115012203fr_esh
gree56641563gree__
greed75125693gree_d
greeds84314283greeds
greedy11518853greedy
greek105915943gree_k
green65522143gree_n
greens75716873greens
greenth11116723greenth
greeny104811453greeny
grees65132473gree_s
greet65835323gree_t
greets75117423greets
grinch1238473grinch
grouch12318473grouch
grutch12285563grutch
heuch135312333_heuch
kench145513923_kench
ketch144912023_ketch
kreep114610413kree_p
kreeps12427413kreeps
kreplech1941583kreplech
kvetch1832993kvetch
leach105422523_leach
lech96825443__lech
letch105215803_letch
merch125417963_merch
orach105219233or_ach
peach125422493_peach
pech116125453__pech
perch124518833_perch
pleach134211243pleach
plench134010813plench
preachy17307313preachy
preact103220393preact
pree67044733pree__
preed85128123pree_d
preen75925053pree_n
preens85020113preens
prees75937173pree_s
prefect141011073prefect
prelect111013833prelect
quench2036633quench
ranch105019793_ranch
ratch104221363_ratch
react74634333_react
rebec94416543_rebec_
rebeck14419913_rebeck
rebecs103913673_rebecs
rec55645463_r_ec_
recce9514563_recce
reck106130563_r_eck
recs65734183_r_ecs
ree37974073_ree__
reed55549623_ree_d
reeds65430903_reeds
reedy910020293_reedy
reef74938213_ree_f
reefs85121663_reefs
reefy114217703_reefy
reek85232523_ree_k
reeks94124033_reeks
reeky125416263_reeky
reel45240533_ree_l
reels55333263_reels
rees45364193_ree_s
reest54938093_reest
reeve84121323_reeve
refect114319333_refect
reject154116283_reject
resect84424703_resect
resh76523453_r_esh
reteach1237413_reteach
rich97025543_r_ich
roach105717003_roach
rotch105815933_rotch
samech13277033samech
screechy1842773screechy
sheesh1237813sheesh
sheuch14267043sheuch
sketch1535363sketch
skreegh15182643skreegh
sneesh945893sneesh
stench114111163stench
stretch1236413stretch
teach105221123_teach
tech95925443__tech
teeth87315853_teeth
tench105620003_tench
teuch105214853_teuch
tree47745813tree__
treed65626733tree_d
treen55622753tree_n
treens65317873treens
trees55835763tree_s
trefah1235093trefah
upreach1444693upreach
ureic74514463ureic_
vetch134411843_vetch
welch134411493_welch
wench136214783_wench
wreath124111193wreath
wreck144611043wr_eck
yecch15558093_yecch
yech127220533__yech

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.376475242.0
2DLD Change Limit1127163095.78019501.0
3Display Results3093090.0933322.6
 (SQL Overall)1786913096.24928595.1
 
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.