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

227 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
beechy1639750(None) 
beachy164011251beachy
beech124315501beech_
reechy14367821reechy
beach124623892beach_
beechen14367702beechen
beeches143413882beeches
beefy135313832bee_fy
beery105220122bee_ry
belch124415502belch_
bench125619502bench_
bitchy16479202bitchy
botchy16537822botchy
breech13348262breech_
bunchy16437462bunchy
leachy14419732leachy
leech104913212leech_
peachy164510842peachy
reecho11318652reecho
techy135612012_techy
tetchy1436002tetchy
yechy16519082_yechy
achy126316093__achy
bach116131393b_ach_
batch124620103batch_
beachboy2042913beachboy
beached154516553beached
beaches144120653beaches
beacon10511373beacon
beady114719923b_eady
beaky146118023b_eaky
beamy126218573b_eamy
beauty115410163beauty
becap114315053b_ecap
beck126226573b_ec_k
becks135522013b_ecks
bedeck1536213bedec_k
bedecks1635793bedecks
bee56262403bee___
beebee10313063beebee
beechier1535633beechier
beechnut1543793beechnut
beedi8711663bee_di
beef96233683bee__f
beefed123510873beefed
beefily1535613beefily
beefs105618563bee_fs
been65335783bee__n
beep85931213bee__p
beeped115313453beeped
beeper103714093beeper
beeps95320973bee_ps
beer65635993bee__r
beers75628393bee_rs
bees65453383bee__s
beet66457543bee__t
beetle8311673beetle
beets76131443bee_ts
beeves114615043beeves
beezer174010523beezer
beigy111110583b_eigy
belady12489933belady
belay105021523b_elay
belched154011843belched
belcher143511493belcher
belches143514343belches
belfry1435073belfry
belly104625493b_elly
benched154713943benched
bencher144113483bencher
benches143918603benches
benday123810813benday
bendy115017253b_endy
benny105217363b_enny
berry104521773b_erry
berth104917883berth_
bertha11429173bertha
berths114712423berths
beseech1453873beseech_
beth96629233b_eth_
beths105519223b_eths
betony114211583betony
betray111511443betray
bevy127115223b_e_vy
beweary1536223beweary
bewray14147733bewray
bey86645423b_e__y
bheesty1542493bheesty
birch124914023birch_
bitch125017763bitch_
bleach133611403bleach_
bleary115112553bleary
blebby1233743blebby
blench133710453blench_
blenny1156203blenny
blocky17388353blocky
blotchy17293973blotchy
bobeche1643843bobeche
boche124216953b_oche
bolshy1444883bolshy
botch126717453botch_
bothy136713963b_othy
brach126123303brach_
brachs134415753brachs
branchy17357913branchy
brashy145210593brashy
breach134213723breach_
bready124511183bready
breathy15328033breathy
brecham1646833brecham
brechan1437223brechan
breeched16337383breeched
breeches15258673breeches
breezy20295853breezy
bricky17489093bricky
broche133612103broche
brothy14519623brothy
brushy14468263brushy
bunch125118603bunch_
bushy135416683b_ushy
butch125416543butch_
catchy16559583catchy
conchy163710223conchy
creche13310763creche
deathy134210233deathy
decay114718483_decay
decoy115716313_decoy
decry115514353_decry
deedy104315893dee_dy
deejay1734523deejay
deeply1257013deeply
descry1256183descry
drecky16486333drecky
duchy144310873_duchy
each95530583_each_
eche97520283__eche
echo96615953__echo
echt95722903__echt
eely77725213_ee_ly
eery76129623_ee_ry
etch95419143_etch_
feebly1436653feebly
fetch134913473fetch_
fitchy17437623fitchy
fleche14299303fleche
flecky18387653flecky
fleech14367343fleech_
fleecy14266483fleec_y
fleshy15406283fleshy
geeky134710733gee_ky
heathy156111213heathy
heuch135312333heuch_
heuchs14447923heuchs
itchy13449013_itchy
keenly1336373keenly
kench145513923kench_
ketch144912023ketch_
kvetchy2241803kvetchy
leach105422523leach_
lech96825443_lech_
leeched13369503leeched
leeches123911933leeches
leery85919133lee_ry
leeway1255883leeway
letch105215803letch_
meekly1535193meekly
meetly1138673meetly
menschy17353993menschy
merch125417963merch_
mercy125916183merc_y
meshy135612783_meshy
needy94614693nee_dy
patchy16509573patchy
peach125422493peach_
pech116125453_pech_
pechs125516203_pechs
pecky165515093_pecky
peery105719443pee_ry
perch124518833perch_
pitchy16479673pitchy
poachy16388963poachy
pouchy16538663pouchy
preachy17307313preachy
punchy16398523punchy
reach105123883reach_
reedy910020283ree_dy
reefy114217703ree_fy
reeky125416263ree_ky
retch104818303retch_
screechy1842763screechy
seedy94821533see_dy
seely84522633see_ly
seemly1138433seemly
seepy104717973see_py
seethe93712483seethe
seiche11811833seiche
sketchy1943043sketchy
speech1347563speech_
stenchy15256213stenchy
teach105221123teach_
tech95925443_tech_
techs106915833_techs
teensy9478273teensy
teeny85417883tee_ny
teeth87315853teeth_
teethe94511313teethe
tench105620003tench_
teuch105214853teuch_
torchy14549533torchy
touchy145010503touchy
veejay1933703veejay
veery115816253vee_ry
vetch134411843vetch_
vichy1639043_vichy
wecht13415443_wecht
weedy125115003wee_dy
weekly1635313weekly
weensy12416823weensy
weeny115316163wee_ny
weepy134212593wee_py
welch134411493welch_
wench136214783wench_
witchy17468593witchy
yecch15558093yecch_
yecchs16414953yecchs
yech127220533_yech_
yechs136112583_yechs

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162277.45315123.6
3Display Results2272270.0633603.2
 (SQL Overall)1786912277.65623340.0
 
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.