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

260 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
cowboy163706(None) 
cowboys1735251cowboys
lowboy1435901lowboy
carboy134914182carboy
cobby145516412co_bby
colby124415062colb_y
combo114519432combo_
combos125316612combos
convoy14348542convoy
copyboy1963512copyboy
corby125018532corb_y
cowboyed1943372cowboyed
cowpox2035002cowpox
cowry135512482cow_ry
cowy126427362cow__y
lowboys1534212lowboys
plowboy1743182plowboy
poboy121612222po_boy
potboy1397812potboy
tomboy1358212tomboy
batboy1387533batboy
blowby16467513blowb_y
bobby114814663bo_bby
bonbon10310073bonbon
booboo1039463booboo
booby125319513boob_y
boubou1038433boubou
bowery146012113bowery
bowpot13410073bowpot
bowwow1334463bowwow
boy87753563___boy
busboy13307443busboy
cabby145314563c_abby
cabob114616813c_abob
callboy1465833callboy
carbo94923843carbo_
carbon104919043carbon
carbos105122263carbos
carboys144711783carboys
choirboy1842233choirboy
chubby1844123chubby
cibol9512023c_ibol
cloy96623833c__loy
clubby1534683clubby
coalbox1844113coalbox
coaly105521593co_aly
cob710258753co_b__
cobb106422003co_b_b
cobber124116843cobber
cobble123615263cobble
cobbs115013993co_bbs
cobia94117513co_bia
coble94823173co_ble
cobra95214403co_bra
cobs87043143co_b_s
cobweb1533243cobweb
cobwebby196583cobwebby
cocky164215933co_cky
coco87330603co_co_
cocoa98517883co_coa
cocoon10312263cocoon
cocos95624693co_cos
codify1537163codify
codon86522853co_don
coelom10310433coelom
coembody1842493coembody
cogon89120903co_gon
cogway1566183cogway
coho97524493co_ho_
cohog117813043co_hog
cohos105921853co_hos
coky137526823co__ky
colbys13407153colbys
coldly12459953coldly
collop107312313collop
colly104926773co_lly
colobi105011083colobi
colog86619933co_log
colon78630193co_lon
colony115417273colony
color76123743co_lor
coly96940533co__ly
comb106632113comb__
combat12316753combat
combe116223543comb_e
combed135516543combed
comber125118503comber
combes125321733combes
combs116122963comb_s
comedy14378233comedy
comely134213733comely
comfy153710213co_mfy
comity13312713comity
common12310803common
commy144712643co_mmy
comply152810383comply
compo115318573compo_
compony1613011913compony
compos124818803compos
conchy163710223conchy
condo85322593condo_
condom114215363condom
condor94616973condor
condos94322333condos
coney105932883co_ney
congo85623133congo_
congos94219883congos
congou94313243congou
conky145818743co_nky
consol82614113consol
conto76027173conto_
contos84923233contos
convey144610223convey
convoys15267023convoys
cony96537833co__ny
coo59566363co__o_
coocoo1069693coocoo
cooey105828223co_oey
coof96643273co__of
cook107236933co__ok
cookey155414333cookey
cooky145321363co_oky
cool66940493co__ol
coolly114811393coolly
cooly105525423co_oly
coon67248943co__on
coop87238653co__op
coos67456493co__os
coot67860383co__ot
copay126516313co_pay
coplot10518273coplot
copy116229803co__py
copyboys2042663copyboys
corban10314693corban
corbel103715973corbel
corbie103618203corbie
cordon95017293cordon
corky145221153co_rky
corny106023273co_rny
corody12149703corody
corrody13136143corrody
cory96941513co__ry
cosey106226713co_sey
cosily113613853cosily
cosmos10311753cosmos
costly114012333costly
cosy97232703co__sy
cotton8312993cotton
cottony1237253cottony
county114313323county
coupon102810993coupon
covary1438743covary
covey136121783co_vey
cow89856713cow___
cowage12310673cowage
coward12411673coward
cowbane1437673cowbane
cowbell1445223cowbell
cowberry1843343cowberry
cowbind1536613cowbind
cowbird1534433cowbird
cowboying2043183cowboying
cowed115637853cow_ed
cowedly1635703cowedly
cower104531773cow_er
cowers114625533cowers
cowflop1742893cowflop
cowier113616163cowier
cowing124526323cowing
cowl97530813cow__l
cowled125218393cowled
cowls106922213cow_ls
cowman13910373cowman
cowmen13810923cowmen
cowpat13312033cowpat
cowpea1337643cowpea
cowpie133511513cowpie
cowplop1643363cowplop
cowpoke1835103cowpoke
cowrie113814283cowrie
cowrote12289673cowrote
cows97046643cow__s
coy810557553c___oy
coydog1335133coydog
coyly135614893co_yly
coypou13268403coypou
cozey196718543co_zey
cozily20349703cozily
cozy185823803co__zy
crabby15346753crabby
crowbar1444273crowbar
crowdy15467173crow_dy
cubby145212123c_ubby
dobby136013633do_bby
doby106022163do_b_y
doubly12328963doubly
dowdy136112543dow_dy
dowery134311663dowery
downbow1653393downbow
downy125714553dow_ny
dowry126312483dow_ry
flyboy17113913flyboy
fogbow1544783fogbow
footboy1544913footboy
forby135317673forb_y
gobo76126903go_bo_
gobony1236913go_bony
gobos86219383go_bos
goby106021083go_b_y
gombo105814043gombo_
gombos114311093gombos
gowany13457493gowany
hobby155913733ho_bby
hobo97026083ho_bo_
hobos106321353ho_bos
homeboy1746153homeboy
hotbox1835703hotbox
howdy155711413how_dy
jowly186410903jow_ly
kobo107422103ko_bo_
kobos115616893ko_bos
kowtow1643463kowtow
lobby125113923lo_bby
lobo67229863lo_bo_
lobos75921843lo_bos
looby108115623loob_y
lowborn1245143lowborn
lowbrow1543273lowbrow
lowery124112713lowery
lowly114113333low_ly
newsboy1542493newsboy
nobby125513463no_bby
nobly105314403no_bly
nobody1235743no_body
nonbody1344823nonbody
noway111112843now_ay
obey96521303_o_bey
oboe66822943_o_boe
obol65220613_o_bol
orby97519603_orb_y
oxbow1734443_oxbow
plowboys1842363plowboys
poboys1397313po_boys
postboy1476673postboy
potboys1475273potboys
powwow1342833powwow
robot7325973ro_bot
rowboat1267983rowboat
rowdy125711533row_dy
shopboy1743803shopboy
toby96322293to_b_y
tomboys1435713tomboys
towboat1258303towboat
towery124012093towery
towny116114493tow_ny
towy105325473tow__y
wobbly16347093wobbly
womby155910093womb_y
yobbo1237873yobbo_
yobbos1335963yobbos

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.390458182.1
2DLD Change Limit1127162605.47020606.2
3Display Results2602600.0803250.0
 (SQL Overall)1786912605.94030082.7
 
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.