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

295 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
botchy1653782(None) 
bitchy16479201bitchy
blotchy17293971blotchy
botch126717451botch_
bothy136713961bot_hy
batch124620102batch_
beachy164011252beachy
beechy16397502beechy
bitch125017762bitch_
blotch13197142blotch_
boche124216952bo_che
bolshy1444882bolshy
botany1139262botany
botched153611902botched
botcher143613222botcher
botchery18366762botchery
botches143716022botches
botchily1864372botchily
botfly1436092botfly
both96533432bot_h_
brothy14519622brot_hy
bunchy16437462bunchy
butch125416542butch_
catchy16559582catchy
conchy163710222conchy
fitchy17437622fitchy
gotcha1234632gotcha
hotch136214722hotch_
itchy13449012_itchy
mothy136214552mot_hy
notch105613322notch_
patchy16509572patchy
pitchy16479672pitchy
poachy16388962poachy
pouchy16538662pouchy
rotch105815932rotch_
rotche114311982rotche
tetchy1436002tetchy
torchy14549532torchy
touchy145010502touchy
witchy17468592witchy
abbotcy1642093abbotc_y
achy126316093__achy
aitch105216163aitch_
bach116131393b_ach_
batboy1387533batboy
batched154114243batched
batcher144414853batcher
batches144019613batches
bath95940083bat_h_
bathe105822883bat_he
baths105922923bat_hs
batty105422243bat_ty
beach124623893beach_
beech124315503beech_
belch124415503belch_
bench125619503bench_
beth96629233bet_h_
beths105519223bet_hs
betony114211583betony
betray111511443betray
biotech14104493biotech_
biotechs15123853biotechs
birch124914023birch_
bitched153212923bitched
bitchen14349733bitchen
bitchery18236563bitchery
bitches144117063bitches
bitchily1844533bitchily
bitsy104511303bit_sy
bitty106119173bit_ty
blocky17388353blocky
blotched1635653blotched
blotches1537433blotches
blotchily1942683blotchily
blotty11178343blot_ty
bobby114814663bo_bby
bobcat12411253bobcat
bobeche1643843bobeche
bocce114313113bo_cce
bocces123912023bocces
bocci113512713bo_cci
boccia12338793boccia
boccie123311453boccie
boccis123911133boccis
boches134618523bo_ches
bock126032513bo_c_k
bocks134526573bo_cks
bodily12310993bodily
body107425673bo__dy
bogey115220233bo_gey
boggy126116073bo_ggy
bogy106426193bo__gy
boho96923323bo__ho
boldly12399423boldly
boney105227313bo_ney
bonny105816623bo_nny
bony96732083bo__ny
booby125319513bo_oby
boocoo1039003boocoo
boody115420403bo_ody
boogey124711523boogey
boogy114518323bo_ogy
boomy125421823bo_omy
bootery1238983bootery
booth105522013booth_
booths115313793booths
booty106125913bo_oty
boozy194917063bo_ozy
borsch1336133borsch_
borscht1445993borscht
borsht11813503borsht
borty105522833bo_rty
bosh96328973bo_sh_
bosky145612393bo_sky
bosomy13509033bosomy
bossy105515973bo_ssy
bot59680403bot___
bota66236503bot__a
botas75328783bot_as
botchedly2042593botchedly
botchers153511543botchers
botchier15287143botchier
botching16359703botching
botel75121863bot_el
botels84815803botels
bother115218063bother
bots66453953bot__s
bott66548573bot__t
bottle84916073bottle
bottom1048713bottom
botts75224863bot_ts
bouchee143313543bouchee
boucle103712783boucle
bough115719313bough_
boughs125414373boughs
bought125115633bought
bouncy13409073bouncy
bounty113411073bounty
bousy104917843bo_usy
bowery146012113bowery
boxcar1734753boxcar
boxily1877843boxily
boxy166420733bo__xy
boy87753563bo___y
boychik2143943boychik
brach126123303brach_
brachs134415753brachs
branchy17357913branchy
brashy145210593brashy
bricky17489093bricky
broach133611113broach_
broche133612103broche
bronchi14176313bronchi
broncho14206463broncho
brooch13368443brooch_
broth106521093brot_h_
broths115013923brot_hs
brushy14468263brushy
bunch125118603bunch_
bushy135416683b_ushy
butcher143411163butcher
butchery18326253butchery
butches144315363butches
butty104020113but_ty
catch125120373catch_
clutchy17323893clutchy
coach125919453coach_
cocky164215933co_cky
conch124620073conch_
concha134213283concha
concho134414263concho
conchs134714903conchs
cooch124916833cooch_
couch125320113couch_
crotch133410083crotch_
cutch125116193cutch_
datcha1266563datcha
ditch115015093ditch_
doth86225713dot_h_
dotty94516103dot_ty
doty86128223dot__y
douche124613223douche
doughy14499843doughy
duchy144310873_duchy
dutch114713823dutch_
etch95419143_etch_
fetch134913473fetch_
fitch134816873fitch_
forwhy1834423forwhy
frothy15578373frot_hy
glitchy16283083glitchy
gotchas1334613gotchas
goth86825083got_h_
goths96513003got_hs
grouchy16294243grouchy
hatch135719593hatch_
hitch134515473hitch_
honcho14389383honcho
hooch135813703hooch_
hootch14386403hootch_
hotched163610923hotched
hotches153814363hotches
hotly115815473hot_ly
hutch135414093hutch_
itch95619173_itch_
jotty155012603jot_ty
ketch144912023ketch_
kitschy1941983kitschy
kvetchy2241803kvetchy
latch104620463latch_
lathy115215063lat_hy
leachy14419733leachy
letch105215803letch_
litchi1137893litchi
loach105116363loach_
loch95527133lo_ch_
lochs106715513lo_chs
lotah85315853lotah_
lotahs9479873lotahs
loth76132133lot_h_
louche115212663louche
match125621103match_
mocha1249923mo_cha
mooch125313613mooch_
motey105922953mot_ey
moth96731333mot_h_
moths106021553mot_hs
motley1139383motley
mouch124715803mouch_
mouthy14409063mouthy
mutch125016173mutch_
mythy16568673myt_hy
natch105018223natch_
notary92310713notary
notched134210303notched
notcher123610933notcher
notches123513653notches
notify1236943notify
ochry13346933_o_chry
ouch95724633_ouch_
outcry1137993outcry
patch125221223patch_
peachy164510843peachy
pitch125018413pitch_
pithy135614463pit_hy
poach124917863poach_
pocky165314603po_cky
poncho133310123poncho
pooch124815303pooch_
porch125918623porch_
potboy1397813potboy
potiche1438043potiche
potsy105815613pot_sy
potty105621003pot_ty
pouch124617083pouch_
punchy16398523punchy
ratch104221363ratch_
reechy14367823reechy
retch104818303retch_
roach105717003roach_
rocky144513853ro_cky
rotary92411303rotary
rotches123515703rotches
rouche114714313rouche
roughy137010853roughy
scotch13207513scotch_
sketchy1943043sketchy
slouchy15454843slouchy
smoochy17223863smoochy
smutchy17193153smutchy
snatchy15355293snatchy
sophy136611763so_phy
soth75932513sot_h_
soths86218623sot_hs
splotchy1841783splotchy
stocky15369153stocky
techy135612013_techy
thatchy1833303thatchy
thy97022913__t_hy
toothy12529693toothy
torch107420933torch_
touch106519393touch_
touche114916173touche
toughy135911073toughy
twitchy18393573twitchy
vetch134411843vetch_
vichy1639043_vichy
votary12248333votary
vouch134611903vouch_
watch135617063watch_
witch134517563witch_
withy144813763wit_hy
worthy15598803worthy
yechy16519083_yechy

Search took 6 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 Limit1127162955.61020092.0
3Display Results2952950.0803687.5
 (SQL Overall)1786912955.83030650.3
 
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.